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 431: po_requisition_headers_all prha,

427: 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,
428: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
429: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
430: from mtl_supply ms,
431: po_requisition_headers_all prha,
432: csp_sec_inventories csi,
433: csp_planning_parameters cpp
434: where ms.req_header_id = prha.requisition_header_id(+)
435: and ms.to_organization_id = csi.organization_id

Line 473: po_requisition_headers_all prha,

469: 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,
470: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
471: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
472: from mtl_supply ms,
473: po_requisition_headers_all prha,
474: csp_planning_parameters cpp
475: where ms.req_header_id = prha.requisition_header_id(+)
476: and ms.to_organization_id = cpp.organization_id
477: and ms.to_subinventory = cpp.secondary_inventory

Line 508: po_requisition_headers_all prha,

504: 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,
505: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
506: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
507: from mtl_supply ms,
508: po_requisition_headers_all prha,
509: csp_planning_parameters cpp
510: where ms.req_header_id = prha.requisition_header_id(+)
511: and cpp.organization_id = ms.to_organization_id
512: and cpp.organization_type = 'W'

Line 543: po_requisition_headers_all prha,

539: 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,
540: sum(decode(ms.supply_type_code,'REQ',decode(nvl(prha.transferred_to_oe_flag,'N'),'N',to_org_primary_quantity,0),0)) requisitions,
541: sum(decode(ms.supply_type_code,'SHIPMENT',to_org_primary_quantity,0)) interorg_transfer
542: from mtl_supply ms,
543: po_requisition_headers_all prha,
544: csp_planning_parameters cpp
545: where ms.req_header_id = prha.requisition_header_id(+)
546: and ms.to_organization_id = cpp.organization_id
547: and ms.item_id > 0

Line 573: po_requisition_headers_all prha,

569: cpp.planning_parameters_id,
570: cpp.level_id,
571: 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))
572: from mtl_supply ms,
573: po_requisition_headers_all prha,
574: csp_planning_parameters cpp
575: where ms.req_header_id = prha.requisition_header_id
576: and cpp.organization_id = ms.from_organization_id
577: and cpp.organization_type = 'W'

Line 602: po_requisition_headers_all prha,

598: cpp.planning_parameters_id,
599: cpp.level_id,
600: 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))
601: from mtl_supply ms,
602: po_requisition_headers_all prha,
603: csp_planning_parameters cpp
604: where prha.requisition_header_id = ms.req_header_id
605: and prha.transferred_to_oe_flag= 'Y'
606: and prha.type_lookup_code = 'INTERNAL'