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 1295: from MSC_SYSTEM_ITEMS

1291:
1292: --dbms_output.put_line('srInstanceId=' || srInstanceId);
1293:
1294: select PLANNER_CODE into v_plannerCode
1295: from MSC_SYSTEM_ITEMS
1296: where INVENTORY_ITEM_ID = inventoryItemId
1297: and plan_id = -1
1298: and ORGANIZATION_ID = orgId;
1299: