DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 5020: FROM MTL_SYSTEM_ITEMS_B_KFV

5016: AND item_number IS NOT NULL
5017: AND NOT EXISTS
5018: (
5019: SELECT 1
5020: FROM MTL_SYSTEM_ITEMS_B_KFV
5021: WHERE organization_id = exe_int.inventory_org_id
5022: AND concatenated_segments = exe_int.item_number
5023: )
5024: )

Line 5040: FROM MTL_SYSTEM_ITEMS_B_KFV

5036: UPDATE zx_exemptions_int exe_int
5037: SET inventory_item_id =
5038: (
5039: SELECT inventory_item_id
5040: FROM MTL_SYSTEM_ITEMS_B_KFV
5041: WHERE organization_id = exe_int.inventory_org_id
5042: AND concatenated_segments = exe_int.item_number
5043: )
5044: WHERE record_status = G_RS_IN_PROCESS