APPS.CSP_SUPPLY_DEMAND_PVT dependencies on MTL_SUPPLY

Line 430: from mtl_supply ms,

426: sum(decode(ms.supply_type_code,'PO',to_org_primary_quantity,'RECEIVING',to_org_primary_quantity,0)) purchase_orders,
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(+)

Line 472: from mtl_supply ms,

468: sum(decode(ms.supply_type_code,'PO',to_org_primary_quantity,'RECEIVING',to_org_primary_quantity,0)) purchase_orders,
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

Line 507: from mtl_supply ms,

503: sum(decode(ms.supply_type_code,'PO',to_org_primary_quantity,'RECEIVING',to_org_primary_quantity,0)) purchase_orders,
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

Line 542: from mtl_supply ms,

538: sum(decode(ms.supply_type_code,'PO',to_org_primary_quantity,'RECEIVING',to_org_primary_quantity,0)) purchase_orders,
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

Line 572: from mtl_supply ms,

568: ms.from_organization_id,
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

Line 601: from mtl_supply ms,

597: ms.from_organization_id,
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'