http://generalledger-gl.blogspot.com/2016/07/fsg-rowset-account-ranges-lisitng.html
PLSQL Query to Get FSG Rowset Account Ranges Listing
select bb.sequence,
bb.description,
tt.SIGN,
tt.SEGMENT1_LOW || '-' || SEGMENT2_LOW || '-' || SEGMENT3_LOW || '-' ||
SEGMENT4_LOW || '-' || SEGMENT5_LOW
|| '-' || SEGMENT6_LOW || '-' || SEGMENT7_LOW || '-' || SEGMENT8_LOW || '-' ||
SEGMENT9_LOW,
tt.SEGMENT1_HIGH || '-' || tt.SEGMENT2_HIGH || '-' ||
tt.SEGMENT3_HIGH || '-' || tt.SEGMENT4_HIGH || '-' ||
tt.SEGMENT5_HIGH
|| '-' || tt.SEGMENT6_HIGH || '-' || tt.SEGMENT7_HIGH || '-' ||
tt.SEGMENT8_HIGH || '-' || tt.SEGMENT9_HIGH,
tt.SEGMENT1_TYPE || tt.SEGMENT2_TYPE || tt.SEGMENT3_TYPE ||
tt.SEGMENT4_TYPE || tt.SEGMENT5_TYPE || tt.SEGMENT6_TYPE ||
tt.SEGMENT7_TYPE || tt.SEGMENT8_TYPE Display
from RG_REPORT_AXIS_CONTENTS tt, RG_REPORT_AXES_V bb
where tt.AXIS_SET_ID = bb.axis_set_id
and tt.AXIS_SEQ = bb.sequence
and bb.axis_set_id = 15207
order by bb.sequence asc
PLSQL Query to Get FSG Rowset Account Ranges Listing
select bb.sequence,
bb.description,
tt.SIGN,
tt.SEGMENT1_LOW || '-' || SEGMENT2_LOW || '-' || SEGMENT3_LOW || '-' ||
SEGMENT4_LOW || '-' || SEGMENT5_LOW
|| '-' || SEGMENT6_LOW || '-' || SEGMENT7_LOW || '-' || SEGMENT8_LOW || '-' ||
SEGMENT9_LOW,
tt.SEGMENT1_HIGH || '-' || tt.SEGMENT2_HIGH || '-' ||
tt.SEGMENT3_HIGH || '-' || tt.SEGMENT4_HIGH || '-' ||
tt.SEGMENT5_HIGH
|| '-' || tt.SEGMENT6_HIGH || '-' || tt.SEGMENT7_HIGH || '-' ||
tt.SEGMENT8_HIGH || '-' || tt.SEGMENT9_HIGH,
tt.SEGMENT1_TYPE || tt.SEGMENT2_TYPE || tt.SEGMENT3_TYPE ||
tt.SEGMENT4_TYPE || tt.SEGMENT5_TYPE || tt.SEGMENT6_TYPE ||
tt.SEGMENT7_TYPE || tt.SEGMENT8_TYPE Display
from RG_REPORT_AXIS_CONTENTS tt, RG_REPORT_AXES_V bb
where tt.AXIS_SET_ID = bb.axis_set_id
and tt.AXIS_SEQ = bb.sequence
and bb.axis_set_id = 15207
order by bb.sequence asc
Como se cambia la fecha de solicitud interna para que pueda capturar en mes anteriores a la fecha de hoy en el modulo de compras o PO
ReplyDeleteComo se cambia la fecha de solicitud interna para que pueda capturar en mes anteriores a la fecha de hoy en el modulo de compras o PO
ReplyDeleteGreat Effort. I really need this one
ReplyDelete