APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 343: FROM mtl_system_items_b item

339: SELECT item_catalog_group_id,
340: lifecycle_id,
341: current_phase_id,
342: inventory_item_status_code
343: FROM mtl_system_items_b item
344: WHERE inventory_item_id = cp_item_id
345: AND organization_id = cp_org_id;
346:
347: --Return Status Variables

Line 369: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;

365: l_new_cc_id NUMBER;
366: l_curr_lifecycle_id NUMBER;
367: l_curr_phase_id NUMBER;
368: l_curr_cc_id NUMBER;
369: l_curr_status_code MTL_SYSTEM_ITEMS_B.inventory_item_status_code%TYPE;
370: --Start 4105841
371: l_event_ret_status VARCHAR2(1);
372: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
373: l_raise_event VARCHAR2(1);

Line 489: UPDATE mtl_system_items_b

485: l_pending_flag := 'N';
486: l_implemented_date := l_sysdate;
487: l_raise_event := 'Y';
488:
489: UPDATE mtl_system_items_b
490: SET lifecycle_id = DECODE(p_new_lifecycle_id,-1,NULL,p_new_lifecycle_id),
491: current_phase_id = DECODE(p_new_phase_id,-1,NULL,p_new_phase_id),
492: last_update_date = l_sysdate,
493: last_updated_by = l_user_id,

Line 776: UPDATE mtl_system_items_b

772: END IF;
773: END LOOP;
774:
775: IF NVL(p_catalog_group_id,-1) <> NVL(p_new_catalog_group_id,-1) THEN
776: UPDATE mtl_system_items_b
777: SET item_catalog_group_id = DECODE(p_new_catalog_group_id,-1,NULL,p_new_catalog_group_id)
778: WHERE inventory_item_id = p_inventory_item_id;
779:
780: -- Bug: 3072079 Added code to update descriptive values of new item catalog group for an item

Line 862: UPDATE MTL_SYSTEM_ITEMS_B

858: --Bug 5220298 Begin
859: IF P_NEW_APPROVAL_STATUS IS NOT NULL
860: THEN
861: --{
862: UPDATE MTL_SYSTEM_ITEMS_B
863: SET APPROVAL_STATUS = p_new_approval_status
864: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
865: AND ORGANIZATION_ID = p_organization_id;
866: --}

Line 1014: FROM mtl_system_items_b

1010:
1011: CURSOR c_get_curr_item_val (cp_item_id IN NUMBER
1012: ,cp_org_id IN NUMBER) IS
1013: SELECT item_catalog_group_id, lifecycle_id, current_phase_id
1014: FROM mtl_system_items_b
1015: WHERE inventory_item_id = cp_item_id
1016: AND organization_id = cp_org_id;
1017:
1018: -- bug: 3802017

Line 1026: FROM mtl_system_items_b itm, mtl_item_revisions_b rev

1022: ,cp_org_id IN NUMBER
1023: ,cp_rev_id IN NUMBER) IS
1024: SELECT itm.item_catalog_group_id, NVL(rev.lifecycle_id,itm.lifecycle_id) lifecycle_id,
1025: NVL(rev.current_phase_id,itm.current_phase_id) current_phase_id
1026: FROM mtl_system_items_b itm, mtl_item_revisions_b rev
1027: WHERE rev.inventory_item_id = cp_item_id
1028: AND rev.organization_id = cp_org_id
1029: AND rev.revision_id = cp_rev_id
1030: AND itm.inventory_item_id = rev.inventory_item_id