Introduction:-This query will provide complete Bill Code and GL String details from Back end
Code:-
SELECT
MSIB.SEGMENT1 Catalog_Item,
MSIB.INVENTORY_ITEM_STATUS_CODE STATUS,
MSIB.DESCRIPTION item_description,msib.PRIMARY_UNIT_OF_MEASURE UOM,IGC.SEGMENT5 “Account Segment”,
(IGC.SEGMENT1||’.’||IGC.SEGMENT2||’.’||IGC.SEGMENT3||’.’||IGC.SEGMENT4||’.’||IGC.SEGMENT5||’.’||IGC.SEGMENT6||’.’||IGC.SEGMENT7||’.’||IGC.SEGMENT8||’.’||IGC.SEGMENT9)”GLC”,
gl_flexfields_pkg.get_concat_description
(igc.chart_of_accounts_id,
igc.code_combination_id
)”Code Combination Desc”
–MC.SEGMENT1 MAJOR_CATEGORY,MC.SEGMENT2 MINOR_CATEGORY
FROM
apps.GL_CODE_COMBINATIONS IGC,
apps.MTL_SYSTEM_ITEMS_B MSIB
WHERE 1=1
and IGC.CODE_COMBINATION_ID = MSIB.SALES_ACCOUNT
—and msib.segment1 in (‘INS-CON-ING-TAP1′)
and msib.INVENTORY_ITEM_STATUS_CODE=’Active’
and ORGANIZATION_ID=855
and msib.segment1 in
(‘INS-CON-ING-IMGDO1’)
Got any queries?
Do drop a note by writing us at yeswanth.r@staging.doyensys.com or use the comment section below to ask your questions
