eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_AATP_PVT dependencies on MSC_SYSTEM_ITEMS

Line 3620: FROM msc_system_items

3616: IF p_identifier = -1 THEN
3617: BEGIN
3618: SELECT inventory_item_id, uom_code
3619: INTO l_inv_item_id, l_uom_code
3620: FROM msc_system_items
3621: WHERE plan_id = p_plan_id
3622: AND sr_instance_id = p_instance_id
3623: AND organization_id = p_organization_id
3624: AND sr_inventory_item_id = p_inventory_item_id;

Line 5989: MSC_SYSTEM_ITEMS I,

5985: FROM MSC_DEPARTMENT_RESOURCES DR,
5986: MSC_SUPPLIES S,
5987: MSC_RESOURCE_REQUIREMENTS REQ,
5988: -- 2859130 MSC_CALENDAR_DATES C,
5989: MSC_SYSTEM_ITEMS I,
5990: MSC_UOM_CONVERSIONS MUC
5991: WHERE DR.PLAN_ID = p_plan_id
5992: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
5993: AND DR.RESOURCE_ID = p_resource_id

Line 6162: MSC_SYSTEM_ITEMS I,

6158: FROM MSC_DEPARTMENT_RESOURCES DR,
6159: MSC_SUPPLIES S,
6160: MSC_RESOURCE_REQUIREMENTS REQ,
6161: MSC_CALENDAR_DATES C,
6162: MSC_SYSTEM_ITEMS I,
6163: MSC_UOM_CONVERSIONS MUC
6164: WHERE DR.PLAN_ID = p_plan_id
6165: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6166: AND DR.RESOURCE_ID = p_resource_id

Line 6381: MSC_SYSTEM_ITEMS I, -- CTO ODR

6377: l_demand_class), 0)) SD_QTY
6378: /*New*/
6379: FROM MSC_DEPARTMENT_RESOURCES DR,
6380: MSC_SUPPLIES S,
6381: MSC_SYSTEM_ITEMS I, -- CTO ODR
6382: MSC_RESOURCE_REQUIREMENTS REQ
6383: -- 2859130 MSC_CALENDAR_DATES C
6384: WHERE DR.PLAN_ID = p_plan_id
6385: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 6545: MSC_SYSTEM_ITEMS I, -- CTO ODR

6541: l_demand_class), 0)) SD_QTY
6542: /*New*/
6543: FROM MSC_DEPARTMENT_RESOURCES DR,
6544: MSC_SUPPLIES S,
6545: MSC_SYSTEM_ITEMS I, -- CTO ODR
6546: MSC_RESOURCE_REQUIREMENTS REQ,
6547: MSC_CALENDAR_DATES C
6548: WHERE DR.PLAN_ID = p_plan_id
6549: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 6862: MSC_SYSTEM_ITEMS I,

6858: FROM MSC_DEPARTMENT_RESOURCES DR,
6859: MSC_SUPPLIES S,
6860: MSC_RESOURCE_REQUIREMENTS REQ,
6861: -- 2859130 MSC_CALENDAR_DATES C,
6862: MSC_SYSTEM_ITEMS I,
6863: MSC_UOM_CONVERSIONS MUC
6864: WHERE DR.PLAN_ID = p_plan_id
6865: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6866: AND DR.RESOURCE_ID = p_resource_id

Line 7153: MSC_SYSTEM_ITEMS I,

7149: FROM MSC_DEPARTMENT_RESOURCES DR,
7150: MSC_SUPPLIES S,
7151: MSC_RESOURCE_REQUIREMENTS REQ,
7152: MSC_CALENDAR_DATES C,
7153: MSC_SYSTEM_ITEMS I,
7154: MSC_UOM_CONVERSIONS MUC
7155: WHERE DR.PLAN_ID = p_plan_id
7156: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7157: AND DR.RESOURCE_ID = p_resource_id

Line 7487: MSC_SYSTEM_ITEMS I, -- CTO ODR

7483: -- For ATP created records use resource_hours
7484: -- End Bug 3348095
7485: FROM MSC_DEPARTMENT_RESOURCES DR,
7486: MSC_SUPPLIES S,
7487: MSC_SYSTEM_ITEMS I, -- CTO ODR
7488: MSC_RESOURCE_REQUIREMENTS REQ
7489: -- 2859130 MSC_CALENDAR_DATES C
7490: WHERE DR.PLAN_ID = p_plan_id
7491: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 7766: MSC_SYSTEM_ITEMS I, -- CTO ODR

7762: -- For ATP created records use resource_hours
7763: -- End Bug 3348095
7764: FROM MSC_DEPARTMENT_RESOURCES DR,
7765: MSC_SUPPLIES S,
7766: MSC_SYSTEM_ITEMS I, -- CTO ODR
7767: MSC_RESOURCE_REQUIREMENTS REQ,
7768: MSC_CALENDAR_DATES C
7769: WHERE DR.PLAN_ID = p_plan_id
7770: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 8668: FROM msc_system_items

8664:
8665: -- get the uom code :bug 1187141
8666: SELECT uom_code, postprocessing_lead_time
8667: INTO l_uom_code, l_postprocessing_lead_time
8668: FROM msc_system_items
8669: WHERE plan_id = p_sup_atp_info_rec.plan_id
8670: AND sr_instance_id = p_sup_atp_info_rec.instance_id
8671: AND organization_id = p_sup_atp_info_rec.organization_id
8672: --AND inventory_item_id = p_sup_atp_info_rec.inventory_item_id;

Line 8894: (select inventory_item_id from msc_system_items msi

8890: AND NVL(P.DISPOSITION_STATUS_TYPE, 1) <> 2 -- Bug 2460645
8891: --consider ATP inserted PO only and palling PO will be tied to forecats
8892: AND ((p.inventory_item_id = l_inv_item_id and p.record_source=2) OR
8893: p.inventory_item_id in
8894: (select inventory_item_id from msc_system_items msi
8895: where msi.base_item_id = l_inv_item_id
8896: and msi.plan_id = p_sup_atp_info_rec.plan_id
8897: and msi.organization_id = p_sup_atp_info_rec.organization_id
8898: and msi.base_item_id = l_inv_item_id))

Line 9340: (select inventory_item_id from msc_system_items msi

9336: --consider ATP inserted POs only. Do not use Planning inserted POs as
9337: -- theu would be tied to forecast
9338: AND ((p.inventory_item_id = l_inv_item_id and p.record_source=2) OR
9339: p.inventory_item_id in
9340: (select inventory_item_id from msc_system_items msi
9341: where msi.base_item_id = l_inv_item_id
9342: and msi.plan_id = p_sup_atp_info_rec.plan_id
9343: and msi.organization_id = p_sup_atp_info_rec.organization_id
9344: and msi.base_item_id = l_inv_item_id))