DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_EXISTING_DOCS dependencies on MTL_SYSTEM_ITEMS_TL

Line 129: FROM PO_LINES_ALL POL, MTL_SYSTEM_ITEMS_TL MTL,

125: POL.ip_category_id, NVL(POL.item_id, NULL_ID), POL.org_id, POL.item_description,
126: POL.attribute13, -- Image
127: POL.attribute14, -- Image URL
128: 'ITEM_TRANSLATION', 'N','Y' -- Attribute, Recreate Attrib, Recreate Attrib TLP
129: FROM PO_LINES_ALL POL, MTL_SYSTEM_ITEMS_TL MTL,
130: FINANCIALS_SYSTEM_PARAMS_ALL FSP
131: WHERE POL.last_updated_program = g_R12_MIGRATION_PROGRAM
132: AND POL.item_id IS NOT NULL
133: AND POL.item_id = MTL.inventory_item_id

Line 725: FROM MTL_SYSTEM_ITEMS_TL MTL, FINANCIALS_SYSTEM_PARAMS_ALL FSP

721: g_R12_MIGRATION_PROGRAM, -- last_updated_program
722: sysdate, -- last_update_date
723: g_R12_UPGRADE_USER, -- created_by
724: sysdate -- creation_date
725: FROM MTL_SYSTEM_ITEMS_TL MTL, FINANCIALS_SYSTEM_PARAMS_ALL FSP
726: WHERE gRecreateAttribTLPRow(i) = 'Y'
727: AND gInvItemIds(i) <> NULL_ID -- Item master items
728: AND gInvItemIds(i) = MTL.inventory_item_id
729: AND gPoOrgIds(i) = FSP.org_id

Line 898: MTL_SYSTEM_ITEMS_TL MTL,

894: NULL, -- Image
895: NULL, -- ImageUrl
896: 'ITEM_TRANSLATION', 'N','Y' -- Attribute, Recreate Attrib, Recreate Attrib TLP
897: FROM PO_REQEXPRESS_LINES_ALL PORL,
898: MTL_SYSTEM_ITEMS_TL MTL,
899: FINANCIALS_SYSTEM_PARAMS_ALL FSP
900: WHERE PORL.last_updated_program = g_R12_MIGRATION_PROGRAM
901: AND item_id IS NOT NULL
902: AND PORL.item_id = MTL.inventory_item_id -- If item had changed then it would have been taken care by 'ITEM_ID' attribute change portion of this sql(it recreates the attributes)