APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 357: FROM mtl_system_items_b item

353: SELECT item_catalog_group_id,
354: lifecycle_id,
355: current_phase_id,
356: inventory_item_status_code
357: FROM mtl_system_items_b item
358: WHERE inventory_item_id = cp_item_id
359: AND organization_id = cp_org_id;
360:
361: --Return Status Variables

Line 383: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;

379: l_new_cc_id NUMBER;
380: l_curr_lifecycle_id NUMBER;
381: l_curr_phase_id NUMBER;
382: l_curr_cc_id NUMBER;
383: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;
384: --Start 4105841
385: l_event_ret_status VARCHAR2(1);
386: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
387: l_raise_event VARCHAR2(1);

Line 503: UPDATE mtl_system_items_b

499: l_pending_flag := 'N';
500: l_implemented_date := l_sysdate;
501: l_raise_event := 'Y';
502:
503: UPDATE mtl_system_items_b
504: SET lifecycle_id = DECODE(p_new_lifecycle_id,-1,NULL,p_new_lifecycle_id),
505: current_phase_id = DECODE(p_new_phase_id,-1,NULL,p_new_phase_id),
506: last_update_date = l_sysdate,
507: last_updated_by = l_user_id,

Line 810: UPDATE mtl_system_items_b

806: END LOOP;
807:
808: /* Bug 9094912. Changing the WHERE clause so that ICC will be changed for only one Master Organization including its Child Organizations. */
809: IF NVL(p_catalog_group_id,-1) <> NVL(p_new_catalog_group_id,-1) THEN
810: UPDATE mtl_system_items_b
811: SET item_catalog_group_id = DECODE(p_new_catalog_group_id,-1,NULL,p_new_catalog_group_id)
812: -- For bug 13473691
813: ,last_update_date = l_sysdate
814: ,last_updated_by = l_user_id

Line 918: UPDATE MTL_SYSTEM_ITEMS_B

914: --Bug 5220298 Begin
915: IF P_NEW_APPROVAL_STATUS IS NOT NULL
916: THEN
917: --{
918: UPDATE MTL_SYSTEM_ITEMS_B
919: SET APPROVAL_STATUS = p_new_approval_status
920: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
921: AND ORGANIZATION_ID = p_organization_id;
922: --}

Line 1081: FROM mtl_system_items_b

1077:
1078: CURSOR c_get_curr_item_val (cp_item_id IN NUMBER
1079: ,cp_org_id IN NUMBER) IS
1080: SELECT item_catalog_group_id, lifecycle_id, current_phase_id
1081: FROM mtl_system_items_b
1082: WHERE inventory_item_id = cp_item_id
1083: AND organization_id = cp_org_id;
1084:
1085: -- bug: 3802017

Line 1093: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

1089: ,cp_org_id IN NUMBER
1090: ,cp_rev_id IN NUMBER) IS
1091: SELECT itm.item_catalog_group_id, NVL(rev.lifecycle_id,itm.lifecycle_id) lifecycle_id,
1092: NVL(rev.current_phase_id,itm.current_phase_id) current_phase_id
1093: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
1094: WHERE rev.inventory_item_id = cp_item_id
1095: AND rev.organization_id = cp_org_id
1096: AND rev.revision_id = cp_rev_id
1097: AND itm.inventory_item_id = rev.inventory_item_id