[Home] [Help]
38: , poh.vendor_site_id
39: , 'Vendor'
40: , poh.note_to_receiver
41: , to_char(poh.org_id) --
42: FROM rcv_supply ms
43: , rcv_transactions rt
44: , po_headers_all poh
45: , po_lines_all pol
46: , po_line_types plt
87: 'Vendor' ,
88: poh.Note_To_Receiver ,
89: to_char(poh.org_id) --
90:
91: FROM rcv_Supply ms ,
92: rcv_Transactions rt,
93: po_Headers_All poh ,
94: mtl_Parameters mp
95: WHERE poh.po_Header_Id = ms.po_Header_Id
245: poh.vendor_site_id ,
246: 'Vendor' ,
247: poh.note_to_receiver ,
248: to_char(poh.org_id)
249: FROM RCV_SUPPLY RSUP,
250: RCV_TRANSACTIONS RT,
251: PO_LOOKUP_CODES PLC,
252: PO_LINES_ALL pol,
253: PO_LINE_LOCATIONS_ALL PLL,
354: OPEN x_po_release_num_lov FOR
355: select distinct pr.release_num
356: , pr.po_release_id
357: , pr.release_date
358: from rcv_supply rsup
359: , po_releases_all pr
360: where rsup.po_header_id = p_po_header_id
361: --AND pr.org_id = p_organization_id
362: and nvl(pr.cancel_flag, 'N') = 'N'
455: , inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
456: p_organization_id,
457: pl.Item_Id)
458: uom_code
459: FROM rcv_supply rsup
460: -- bug 2805640
461: , mtl_units_of_measure mum
462: , po_lines_all pl
463: , mtl_system_items_vl msi
582: rsh.freight_carrier_code
583: FROM
584: rcv_shipment_headers rsh,
585: rcv_shipment_lines rsl,
586: rcv_supply ms,
587: rcv_transactions rt,
588: org_organization_definitions ood
589: WHERE rsh.shipment_header_id = ms.shipment_header_id
590: AND ms.to_organization_id = p_organization_id
685: rsh.packing_slip,
686: rsh.bill_of_lading,
687: rsh.waybill_airbill_num,
688: rsh.freight_carrier_code
689: FROM RCV_SUPPLY RSUP,
690: RCV_SHIPMENT_LINES RSL,
691: RCV_TRANSACTIONS RT,
692: RCV_SHIPMENT_HEADERS RSH,
693: PO_LOOKUP_CODES PLC,
757: NULL,
758: to_char(prh.org_id) --
759: FROM
760: po_requisition_headers prh,
761: rcv_supply ms,
762: po_requisition_lines prl,
763: rcv_transactions rt
764: WHERE
765: prh.requisition_header_id = ms.req_header_id
921: , rsh.shipment_header_id
922: , rsh.shipment_num
923: , rt.po_header_id
924: , rt.oe_order_header_id
925: FROM rcv_supply ms
926: , rcv_transactions rt
927: , rcv_shipment_headers rsh
928: , rcv_shipment_lines rsl
929: , mtl_parameters mp
1076: rsup.shipment_header_id ,
1077: null ,
1078: null ,
1079: null
1080: FROM RCV_SUPPLY RSUP,
1081: RCV_TRANSACTIONS RT,
1082: RCV_SHIPMENT_HEADERS RSH,
1083: RCV_SHIPMENT_LINES RSL,
1084: PO_LOOKUP_CODES PLC,
1149: oec.customer_id,
1150: oec.name customer_name,
1151: oec.customer_number
1152: FROM rcv_transactions rt,
1153: rcv_supply ms,
1154: oe_order_headers_all oeh,
1155: oe_order_lines_all oel,
1156: -- oe_line_types_v oet,
1157: OE_TRANSACTION_TYPES_TL OTT_TL,
3000: , inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
3001: p_organization_id,
3002: pl.Item_Id)
3003: uom_code
3004: FROM rcv_supply rsup
3005: , mtl_units_of_measure mum
3006: , po_lines_all pl
3007: , mtl_system_items_vl msi
3008: WHERE rsup.po_line_id = pl.po_line_id
3159: OPEN x_po_release_num_lov FOR
3160: select distinct pr.release_num
3161: , pr.po_release_id
3162: , pr.release_date
3163: from rcv_supply rsup
3164: , po_releases_all pr
3165: where rsup.po_header_id = p_po_header_id
3166: --AND pr.org_id = p_organization_id
3167: and nvl(pr.cancel_flag, 'N') = 'N'
7548: AND concatenated_segments like p_concatenated_segments
7549: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7550: AND msik.inventory_item_id IN (
7551: SELECT item_id
7552: from rcv_supply
7553: WHERE shipment_header_id = p_shipmentHeaderReceipt
7554: )
7555: UNION
7556:
7612: OR mcr.org_independent_flag = 'Y' )
7613: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7614: AND msik.inventory_item_id IN (
7615: SELECT item_id
7616: from rcv_supply
7617: WHERE shipment_header_id = p_shipmentHeaderReceipt
7618: );
7619:
7620: ELSIF (p_poHeaderID IS NOT NULL ) THEN
7672: WHERE
7673: organization_id = p_Organization_Id
7674: AND concatenated_segments like p_concatenated_segments
7675: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7676: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_release_id = p_poReleaseID)
7677: UNION
7678: select
7679: concatenated_segments,
7680: msik.inventory_item_id,
7731: AND mcr.cross_reference like g_crossref
7732: AND (mcr.organization_id = msik.organization_id
7733: OR mcr.org_independent_flag = 'Y' )
7734: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7735: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_release_id = p_poReleaseID);
7736:
7737: ELSIF (p_poLineID IS NOT null ) THEN
7738: open x_items for
7739: SELECT
7787: WHERE
7788: organization_id = p_Organization_Id
7789: AND concatenated_segments like p_concatenated_segments
7790: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7791: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_line_id = p_poLineID )
7792: UNION
7793: select
7794: concatenated_segments,
7795: msik.inventory_item_id,
7846: AND mcr.cross_reference like g_crossref
7847: AND (mcr.organization_id = msik.organization_id
7848: OR mcr.org_independent_flag = 'Y' )
7849: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7850: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID and po_line_id = p_poLineID );
7851:
7852: ELSE
7853: open x_items for
7854: SELECT
7902: WHERE
7903: organization_id = p_Organization_Id
7904: AND concatenated_segments like p_concatenated_segments
7905: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7906: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID )
7907: UNION
7908: select
7909: concatenated_segments,
7910: msik.inventory_item_id,
7961: AND mcr.cross_reference like g_crossref
7962: AND (mcr.organization_id = msik.organization_id
7963: OR mcr.org_independent_flag = 'Y' )
7964: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7965: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE po_header_id = p_poHeaderID );
7966: end if;
7967:
7968: ELSIF (p_shipmentHeaderID IS NOT null ) THEN
7969: open x_items for
8018: WHERE
8019: organization_id = p_Organization_Id
8020: AND concatenated_segments like p_concatenated_segments
8021: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8022: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE SHIPMENT_HEADER_ID = p_shipmentHeaderID )
8023: UNION
8024: select
8025: concatenated_segments,
8026: msik.inventory_item_id,
8077: AND mcr.cross_reference like g_crossref
8078: AND (mcr.organization_id = msik.organization_id
8079: OR mcr.org_independent_flag = 'Y' )
8080: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8081: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE SHIPMENT_HEADER_ID = p_shipmentHeaderID );
8082:
8083: ELSIF (p_reqHeaderID IS NOT NULL ) THEN
8084: open x_items for
8085: SELECT
8248: WHERE
8249: organization_id = p_Organization_Id
8250: AND concatenated_segments like p_concatenated_segments
8251: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8252: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE OE_ORDER_HEADER_ID = p_oeOrderHeaderID )
8253: UNION
8254: select
8255: concatenated_segments,
8256: msik.inventory_item_id,
8307: AND mcr.cross_reference like g_crossref
8308: AND (mcr.organization_id = msik.organization_id
8309: OR mcr.org_independent_flag = 'Y' )
8310: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
8311: AND msik.inventory_item_id IN (SELECT item_id FROM rcv_supply WHERE OE_ORDER_HEADER_ID = p_oeOrderHeaderID );
8312:
8313: END IF;
8314:
8315: END GET_INV_ITEM_LOV_RECEIVING;