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.CSP_SUPPLY_DEMAND_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 430: po_requisition_headers_all prha,

426: sum(decode(ms.supply_type_code,'REQ',decode(prha.transferred_to_oe_flag,'Y',decode(prha.type_lookup_code,'INTERNAL',to_org_primary_quantity),0),0)) internal_orders,
427: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
428: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
429: from mtl_supply ms,
430: po_requisition_headers_all prha,
431: csp_sec_inventories csi,
432: csp_planning_parameters cpp
433: where ms.req_header_id = prha.requisition_header_id(+)
434: and ms.to_organization_id = csi.organization_id

Line 472: po_requisition_headers_all prha,

468: sum(decode(ms.supply_type_code,'REQ',decode(prha.transferred_to_oe_flag,'Y',decode(prha.type_lookup_code,'INTERNAL',to_org_primary_quantity),0),0)) internal_orders,
469: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
470: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
471: from mtl_supply ms,
472: po_requisition_headers_all prha,
473: csp_planning_parameters cpp
474: where ms.req_header_id = prha.requisition_header_id(+)
475: and ms.to_organization_id = cpp.organization_id
476: and ms.to_subinventory = cpp.secondary_inventory

Line 507: po_requisition_headers_all prha,

503: sum(decode(ms.supply_type_code,'REQ',decode(prha.transferred_to_oe_flag,'Y',decode(prha.type_lookup_code,'INTERNAL',to_org_primary_quantity),0),0)) internal_orders,
504: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
505: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
506: from mtl_supply ms,
507: po_requisition_headers_all prha,
508: csp_planning_parameters cpp
509: where ms.req_header_id = prha.requisition_header_id(+)
510: and cpp.organization_id = ms.to_organization_id
511: and cpp.organization_type = 'W'

Line 542: po_requisition_headers_all prha,

538: sum(decode(ms.supply_type_code,'REQ',decode(prha.transferred_to_oe_flag,'Y',decode(prha.type_lookup_code,'INTERNAL',to_org_primary_quantity),0),0)) internal_orders,
539: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
540: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
541: from mtl_supply ms,
542: po_requisition_headers_all prha,
543: csp_planning_parameters cpp
544: where ms.req_header_id = prha.requisition_header_id(+)
545: and ms.to_organization_id = cpp.organization_id
546: and ms.item_id > 0

Line 572: po_requisition_headers_all prha,

568: cpp.planning_parameters_id,
569: cpp.level_id,
570: sum(decode(ms.supply_type_code,'REQ',decode(prha.transferred_to_oe_flag,'Y',decode(prha.type_lookup_code,'INTERNAL',to_org_primary_quantity),0),0))
571: from mtl_supply ms,
572: po_requisition_headers_all prha,
573: csp_planning_parameters cpp
574: where ms.req_header_id = prha.requisition_header_id
575: and cpp.organization_id = ms.from_organization_id
576: and cpp.organization_type = 'W'

Line 601: po_requisition_headers_all prha,

597: cpp.planning_parameters_id,
598: cpp.level_id,
599: sum(decode(ms.supply_type_code,'REQ',decode(prha.transferred_to_oe_flag,'Y',decode(prha.type_lookup_code,'INTERNAL',to_org_primary_quantity),0),0))
600: from mtl_supply ms,
601: po_requisition_headers_all prha,
602: csp_planning_parameters cpp
603: where prha.requisition_header_id = ms.req_header_id
604: and prha.transferred_to_oe_flag= 'Y'
605: and prha.type_lookup_code = 'INTERNAL'