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 3844: FROM msc_system_items

3840: IF p_identifier = -1 THEN
3841: BEGIN
3842: SELECT inventory_item_id, uom_code
3843: INTO l_inv_item_id, l_uom_code
3844: FROM msc_system_items
3845: WHERE plan_id = p_plan_id
3846: AND sr_instance_id = p_instance_id
3847: AND organization_id = p_organization_id
3848: AND sr_inventory_item_id = p_inventory_item_id;

Line 6219: MSC_SYSTEM_ITEMS I,

6215: FROM MSC_DEPARTMENT_RESOURCES DR,
6216: MSC_SUPPLIES S,
6217: MSC_RESOURCE_REQUIREMENTS REQ,
6218: -- 2859130 MSC_CALENDAR_DATES C,
6219: MSC_SYSTEM_ITEMS I,
6220: MSC_UOM_CONVERSIONS MUC
6221: WHERE DR.PLAN_ID = p_plan_id
6222: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6223: AND DR.RESOURCE_ID = p_resource_id

Line 6392: MSC_SYSTEM_ITEMS I,

6388: FROM MSC_DEPARTMENT_RESOURCES DR,
6389: MSC_SUPPLIES S,
6390: MSC_RESOURCE_REQUIREMENTS REQ,
6391: MSC_CALENDAR_DATES C,
6392: MSC_SYSTEM_ITEMS I,
6393: MSC_UOM_CONVERSIONS MUC
6394: WHERE DR.PLAN_ID = p_plan_id
6395: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6396: AND DR.RESOURCE_ID = p_resource_id

Line 6611: MSC_SYSTEM_ITEMS I, -- CTO ODR

6607: l_demand_class), 0)) SD_QTY
6608: /*New*/
6609: FROM MSC_DEPARTMENT_RESOURCES DR,
6610: MSC_SUPPLIES S,
6611: MSC_SYSTEM_ITEMS I, -- CTO ODR
6612: MSC_RESOURCE_REQUIREMENTS REQ
6613: -- 2859130 MSC_CALENDAR_DATES C
6614: WHERE DR.PLAN_ID = p_plan_id
6615: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 6775: MSC_SYSTEM_ITEMS I, -- CTO ODR

6771: l_demand_class), 0)) SD_QTY
6772: /*New*/
6773: FROM MSC_DEPARTMENT_RESOURCES DR,
6774: MSC_SUPPLIES S,
6775: MSC_SYSTEM_ITEMS I, -- CTO ODR
6776: MSC_RESOURCE_REQUIREMENTS REQ,
6777: MSC_CALENDAR_DATES C
6778: WHERE DR.PLAN_ID = p_plan_id
6779: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 7092: MSC_SYSTEM_ITEMS I,

7088: FROM MSC_DEPARTMENT_RESOURCES DR,
7089: MSC_SUPPLIES S,
7090: MSC_RESOURCE_REQUIREMENTS REQ,
7091: -- 2859130 MSC_CALENDAR_DATES C,
7092: MSC_SYSTEM_ITEMS I,
7093: MSC_UOM_CONVERSIONS MUC
7094: WHERE DR.PLAN_ID = p_plan_id
7095: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7096: AND DR.RESOURCE_ID = p_resource_id

Line 7383: MSC_SYSTEM_ITEMS I,

7379: FROM MSC_DEPARTMENT_RESOURCES DR,
7380: MSC_SUPPLIES S,
7381: MSC_RESOURCE_REQUIREMENTS REQ,
7382: MSC_CALENDAR_DATES C,
7383: MSC_SYSTEM_ITEMS I,
7384: MSC_UOM_CONVERSIONS MUC
7385: WHERE DR.PLAN_ID = p_plan_id
7386: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7387: AND DR.RESOURCE_ID = p_resource_id

Line 7717: MSC_SYSTEM_ITEMS I, -- CTO ODR

7713: -- For ATP created records use resource_hours
7714: -- End Bug 3348095
7715: FROM MSC_DEPARTMENT_RESOURCES DR,
7716: MSC_SUPPLIES S,
7717: MSC_SYSTEM_ITEMS I, -- CTO ODR
7718: MSC_RESOURCE_REQUIREMENTS REQ
7719: -- 2859130 MSC_CALENDAR_DATES C
7720: WHERE DR.PLAN_ID = p_plan_id
7721: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 7996: MSC_SYSTEM_ITEMS I, -- CTO ODR

7992: -- For ATP created records use resource_hours
7993: -- End Bug 3348095
7994: FROM MSC_DEPARTMENT_RESOURCES DR,
7995: MSC_SUPPLIES S,
7996: MSC_SYSTEM_ITEMS I, -- CTO ODR
7997: MSC_RESOURCE_REQUIREMENTS REQ,
7998: MSC_CALENDAR_DATES C
7999: WHERE DR.PLAN_ID = p_plan_id
8000: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 8899: FROM msc_system_items

8895:
8896: -- get the uom code :bug 1187141
8897: SELECT uom_code, postprocessing_lead_time
8898: INTO l_uom_code, l_postprocessing_lead_time
8899: FROM msc_system_items
8900: WHERE plan_id = p_sup_atp_info_rec.plan_id
8901: AND sr_instance_id = p_sup_atp_info_rec.instance_id
8902: AND organization_id = p_sup_atp_info_rec.organization_id
8903: --AND inventory_item_id = p_sup_atp_info_rec.inventory_item_id;

Line 9125: (select inventory_item_id from msc_system_items msi

9121: AND NVL(P.DISPOSITION_STATUS_TYPE, 1) <> 2 -- Bug 2460645
9122: --consider ATP inserted PO only and palling PO will be tied to forecats
9123: AND ((p.inventory_item_id = l_inv_item_id and p.record_source=2) OR
9124: p.inventory_item_id in
9125: (select inventory_item_id from msc_system_items msi
9126: where msi.base_item_id = l_inv_item_id
9127: and msi.plan_id = p_sup_atp_info_rec.plan_id
9128: and msi.organization_id = p_sup_atp_info_rec.organization_id
9129: and msi.base_item_id = l_inv_item_id))

Line 9571: (select inventory_item_id from msc_system_items msi

9567: --consider ATP inserted POs only. Do not use Planning inserted POs as
9568: -- theu would be tied to forecast
9569: AND ((p.inventory_item_id = l_inv_item_id and p.record_source=2) OR
9570: p.inventory_item_id in
9571: (select inventory_item_id from msc_system_items msi
9572: where msi.base_item_id = l_inv_item_id
9573: and msi.plan_id = p_sup_atp_info_rec.plan_id
9574: and msi.organization_id = p_sup_atp_info_rec.organization_id
9575: and msi.base_item_id = l_inv_item_id))