DBA Data[Home] [Help]

APPS.CTO_GOP_INTERFACE_PK dependencies on MTL_SYSTEM_ITEMS

Line 337: FROM mtl_system_items MTL

333: --of stats on the temp table, hence hints should be used to ensure the optimal join order.
334:
335: UPDATE /*+ INDEX (GT BOM_CTO_ORDER_LINES_GT_N5) */ bom_cto_order_lines_gt GT
336: SET GT.config_creation = ( SELECT nvl(MTL.config_orgs,1)--3555026
337: FROM mtl_system_items MTL
338: WHERE MTL.inventory_item_id = GT.inventory_item_id -- bugfix 3391383
339: AND MTL.organization_id = GT.validation_org--3555026
340: AND GT.bom_item_type = '1'
341: AND GT.config_item_id is not null