APPS.CSP_SUPPLY_DEMAND_PVT dependencies on MTL_SUPPLY

Line 429: from mtl_supply ms,

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

Line 471: from mtl_supply ms,

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

Line 506: from mtl_supply ms,

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

Line 541: from mtl_supply ms,

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

Line 571: from mtl_supply ms,

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

Line 600: from mtl_supply ms,

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