APPS.MSC_WS_OTM_BPEL dependencies on MSC_SYSTEM_ITEMS

Line 46: from msc_system_items

42: dbms_output.put_line(' planId' || planId );
43: dbms_output.put_line('srInstanceId' || srInstanceId);*/
44:
45: select POSTPROCESSING_LEAD_TIME into v_leadTime
46: from msc_system_items
47: where inventory_item_id = itemId
48: and organization_id = orgid -- You need both organziation id and inventory_item_id to get an unique item
49: and msc_system_items.plan_id = planId
50: and msc_system_items.sr_instance_id = srInstanceId;

Line 49: and msc_system_items.plan_id = planId

45: select POSTPROCESSING_LEAD_TIME into v_leadTime
46: from msc_system_items
47: where inventory_item_id = itemId
48: and organization_id = orgid -- You need both organziation id and inventory_item_id to get an unique item
49: and msc_system_items.plan_id = planId
50: and msc_system_items.sr_instance_id = srInstanceId;
51:
52: if v_leadTime is null then
53: v_leadTime :=0;

Line 50: and msc_system_items.sr_instance_id = srInstanceId;

46: from msc_system_items
47: where inventory_item_id = itemId
48: and organization_id = orgid -- You need both organziation id and inventory_item_id to get an unique item
49: and msc_system_items.plan_id = planId
50: and msc_system_items.sr_instance_id = srInstanceId;
51:
52: if v_leadTime is null then
53: v_leadTime :=0;
54: end if;

Line 1320: from MSC_SYSTEM_ITEMS

1316:
1317: --dbms_output.put_line('srInstanceId=' || srInstanceId);
1318:
1319: select PLANNER_CODE into v_plannerCode
1320: from MSC_SYSTEM_ITEMS
1321: where INVENTORY_ITEM_ID = inventoryItemId
1322: and plan_id = -1
1323: and ORGANIZATION_ID = orgId;
1324: