APPS.INVPVDR7 dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 1764: update MTL_ITEM_CATEGORIES_INTERFACE

1760: and set_process_id + 0 = xset_id
1761: and process_flag = 46
1762: and organization_id = cr.organization_id;
1763:
1764: update MTL_ITEM_CATEGORIES_INTERFACE
1765: set process_flag = DECODE(status,0,4,3)
1766: where process_flag = 4
1767: and set_process_id = xset_id
1768: and inventory_item_id = l_item_id

Line 1797: **mtl_item_categories_interface

1793: and organization_id = cr.organization_id;
1794:
1795: /*NP 04/11/95 Also need to reset process_flag = 3 for child
1796: **reset process_flag = 3 for table
1797: **mtl_item_categories_interface
1798: **and set process_flag = 3 for mtl_item_revisions_interface
1799: ** for the relevant inventory_item_id
1800: */
1801: update MTL_ITEM_CATEGORIES_INTERFACE

Line 1801: update MTL_ITEM_CATEGORIES_INTERFACE

1797: **mtl_item_categories_interface
1798: **and set process_flag = 3 for mtl_item_revisions_interface
1799: ** for the relevant inventory_item_id
1800: */
1801: update MTL_ITEM_CATEGORIES_INTERFACE
1802: set process_flag = l_process_flag_3,
1803: request_id = reqst_id,
1804: program_application_id = nvl(program_application_id,prog_appid)
1805: ,