APPS.INVPVDR7 dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 1778: update MTL_ITEM_CATEGORIES_INTERFACE

1774: and set_process_id = xset_id
1775: and process_flag = 46
1776: and organization_id = cr.organization_id;
1777:
1778: update MTL_ITEM_CATEGORIES_INTERFACE
1779: set process_flag = DECODE(status,0,4,3)
1780: where process_flag = 4
1781: and set_process_id = xset_id
1782: and inventory_item_id = l_item_id

Line 1812: **mtl_item_categories_interface

1808: and organization_id = cr.organization_id;
1809:
1810: /*NP 04/11/95 Also need to reset process_flag = 3 for child
1811: **reset process_flag = 3 for table
1812: **mtl_item_categories_interface
1813: **and set process_flag = 3 for mtl_item_revisions_interface
1814: ** for the relevant inventory_item_id
1815: */
1816: update MTL_ITEM_CATEGORIES_INTERFACE

Line 1816: update MTL_ITEM_CATEGORIES_INTERFACE

1812: **mtl_item_categories_interface
1813: **and set process_flag = 3 for mtl_item_revisions_interface
1814: ** for the relevant inventory_item_id
1815: */
1816: update MTL_ITEM_CATEGORIES_INTERFACE
1817: set process_flag = l_process_flag_3,
1818: request_id = reqst_id,
1819: program_application_id = nvl(program_application_id,prog_appid)
1820: ,