APPS.EGO_LIFECYCLE_USER_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 322: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;

318: l_api_name VARCHAR2(30);
319: l_curr_sequence NUMBER;
320: l_future_sequence NUMBER;
321: l_phase_change_code EGO_LCPHASE_POLICY.ACTION_CODE%TYPE;
322: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
323: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
324: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
325: l_current_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
326: l_associated_here VARCHAR2(1);

Line 323: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;

319: l_curr_sequence NUMBER;
320: l_future_sequence NUMBER;
321: l_phase_change_code EGO_LCPHASE_POLICY.ACTION_CODE%TYPE;
322: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
323: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
324: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
325: l_current_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
326: l_associated_here VARCHAR2(1);
327:

Line 324: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;

320: l_future_sequence NUMBER;
321: l_phase_change_code EGO_LCPHASE_POLICY.ACTION_CODE%TYPE;
322: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
323: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
324: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
325: l_current_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
326: l_associated_here VARCHAR2(1);
327:
328: l_policy_object_name VARCHAR2(30);

Line 325: l_current_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;

321: l_phase_change_code EGO_LCPHASE_POLICY.ACTION_CODE%TYPE;
322: l_inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE;
323: l_organization_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE;
324: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
325: l_current_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
326: l_associated_here VARCHAR2(1);
327:
328: l_policy_object_name VARCHAR2(30);
329: l_policy_code VARCHAR2(30);

Line 441: MTL_SYSTEM_ITEMS_B

437:
438: SELECT
439: ITEM_CATALOG_GROUP_ID into l_current_catalog_category_id
440: FROM
441: MTL_SYSTEM_ITEMS_B
442: WHERE
443: ORGANIZATION_ID = l_organization_id
444: AND INVENTORY_ITEM_ID = l_inventory_item_id;
445:

Line 787: FROM mtl_system_items_b item

783: -- sync phase changes of items which are not in the same phase of project
784: AND ( (revision_id IS NULL
785: AND NOT EXISTS
786: (SELECT 'X'
787: FROM mtl_system_items_b item
788: WHERE item.inventory_item_id = proj.inventory_item_id
789: AND item.organization_id = proj.organization_id
790: AND item.lifecycle_id = p_lifecycle_id
791: AND item.current_phase_id = p_phase_id

Line 844: FROM MTL_SYSTEM_ITEMS_B msi

840: -- validate the current status code in the new phase; if current status exists
841: -- in the new phase, keep it; otherwise, use the default status
842: SELECT msi.INVENTORY_ITEM_STATUS_CODE
843: INTO l_status_code
844: FROM MTL_SYSTEM_ITEMS_B msi
845: WHERE msi.INVENTORY_ITEM_ID = l_item_record.INVENTORY_ITEM_ID
846: AND msi.ORGANIZATION_ID = l_item_record.ORGANIZATION_ID;
847:
848: BEGIN

Line 1110: MTL_SYSTEM_ITEMS_B

1106: --Bug: 2871650 getting Current phase id to compare
1107: SELECT
1108: CURRENT_PHASE_ID INTO l_current_phase_id
1109: FROM
1110: MTL_SYSTEM_ITEMS_B
1111: WHERE
1112: INVENTORY_ITEM_ID = p_inventory_item_id
1113: AND ORGANIZATION_ID = p_organization_id;
1114: