[Home] [Help]
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
47: , mtl_parameters mp
65: AND msik.mtl_transactions_enabled_flag = 'N'))))
66: AND poh.segment1 LIKE (p_po_number)
67: AND (exists
68: (SELECT 1
69: FROM rcv_transactions rt1
70: WHERE rt1.transaction_id = rt.transaction_id
71: AND rt1.inspection_status_code <> 'NOT INSPECTED'
72: AND rt1.routing_header_id = 2)
73: OR rt.routing_header_id <> 2
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
96: AND ms.Quantity > 0
131: ))))
132: AND poh.Segment1 LIKE (p_po_number)
133: AND (EXISTS
134: (SELECT 1
135: FROM rcv_Transactions rt1
136: WHERE rt1.Transaction_Id = rt.Transaction_Id
137: AND rt1.Inspection_Status_Code <> 'NOT INSPECTED'
138: AND rt1.RoutIng_Header_Id = 2
139: )
233: ELSIF p_mobile_form = 'INSPECT' THEN
234: OPEN x_po_num_lov FOR
235: /*Bug: 4951739
236: Modified query: Referencing base table instead of
237: RCV_TRANSACTIONS_V
238: */
239: SELECT DISTINCT poh.segment1 ,
240: poh.po_header_id ,
241: poh.type_lookup_code ,
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,
254: PO_HEADERS_ALL POH,
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
591: AND rt.organization_id = p_organization_id
596: AND rsl.shipment_header_id = rsh.shipment_header_id
597: AND Nvl(ms.quantity,0) > 0
598: AND (exists
599: (SELECT 1
600: FROM rcv_transactions rt1
601: WHERE rt1.transaction_id = rt.transaction_id
602: AND rt1.inspection_status_code <> 'NOT INSPECTED'
603: AND rt1.routing_header_id = 2)
604: OR rt.routing_header_id <> 2
672: ELSIF p_mobile_form = 'INSPECT' THEN
673: OPEN x_shipment_num_lov FOR
674: /*Bug: 4951739
675: Modified query: Referencing base table instead of
676: RCV_TRANSACTIONS_V
677: */
678: SELECT DISTINCT rsh.shipment_num,
679: rsh.shipment_header_id,
680: rsh.shipped_date,
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,
694: PO_LINE_LOCATIONS_ALL PLL,
695: HR_ALL_ORGANIZATION_UNITS_TL OOD
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
766: AND prl.requisition_header_id = prh.requisition_header_id
767: AND prl.destination_organization_id = p_organization_id
776: -- Added the following line to avoid a full table scan
777: AND rt.requisition_line_id = prl.requisition_line_id
778: AND (exists
779: (SELECT 1
780: FROM rcv_transactions rt1
781: WHERE rt1.transaction_id = rt.transaction_id
782: AND rt1.inspection_status_code <> 'NOT INSPECTED'
783: AND rt1.routing_header_id = 2)
784: OR rt.routing_header_id <> 2
836: AND exists
837: (SELECT 1
838: FROM rcv_shipment_lines rsl,
839: rcv_shipment_headers rsh,
840: rcv_transactions_v rtv
841: WHERE rsl.requisition_line_id = prl.requisition_line_id
842: AND rsh.shipment_header_id = rsl.shipment_header_id
843: AND rtv.shipment_header_id = rsh.shipment_header_id
844: AND rtv.shipment_line_id = rsl.shipment_line_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
930: WHERE rsh.shipment_header_id = ms.shipment_header_id
957: AND rt.transaction_type IN ('ACCEPT','MATCH','RECEIVE',
958: 'REJECT','RETURN TO RECEIVING','TRANSFER')
959: AND (exists
960: (SELECT 1
961: FROM rcv_transactions rt1
962: WHERE rt1.transaction_id = rt.transaction_id
963: AND rt1.inspection_status_code <> 'NOT INSPECTED'
964: AND rt1.routing_header_id = 2)
965: OR rt.routing_header_id <> 2
1068: begin
1069: OPEN x_getRcptNumLOV FOR
1070: /*Bug: 4951739
1071: Modified query: Referencing base table instead of
1072: RCV_TRANSACTIONS_V
1073: */
1074: SELECT DISTINCT rsh.receipt_num ,
1075: null ,
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,
1085: PO_LINE_LOCATIONS_ALL PLL,
1148: OTT_ALL.ORDER_CATEGORY_CODE ORDER_TYPE_CODE, --OLT.ORDER_CATEGORY_CODE ORDER_TYPE_CODE,
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,
1175: -- AND oel.line_type_id = oet.line_type_id
1176: AND oeh.sold_to_org_id = oec.customer_id
1177: AND (exists
1178: (SELECT 1
1179: FROM rcv_transactions rt1
1180: WHERE rt1.transaction_id = rt.transaction_id
1181: AND rt1.inspection_status_code <> 'NOT INSPECTED'
1182: AND rt1.routing_header_id = 2)
1183: OR rt.routing_header_id <> 2
1253: -- oet.ORDER_CATEGORY_CODE ,
1254: oec.customer_id,
1255: oec.name customer_name,
1256: oec.customer_number
1257: FROM rcv_transactions_v rtv,
1258: oe_order_headers_all oeh,
1259: OE_TRANSACTION_TYPES_TL OTT_TL,
1260: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1261: oe_order_lines_all oel,