DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on PO_HEADERS_ALL

Line 238: po_headers_all po ,

234: FROM rcv_transactions rt,
235: mtl_system_items_kfv im,
236: mtl_parameters so,
237: rcv_shipment_lines sl,
238: po_headers_all po ,
239: rcv_shipment_headers sh,
240: hr_operating_units hou --RLNAGARA B5018797
241: WHERE rt.TRANSACTION_ID = l_event_key
242: AND rt.shipment_header_id = sl.shipment_header_id

Line 297: po_headers_all po ,

293: FROM rcv_transactions rt,
294: mtl_system_items_b_kfv im,
295: mtl_parameters so,
296: rcv_shipment_lines sl,
297: po_headers_all po ,
298: rcv_shipment_headers sh ,
299: rcv_lot_transactions tran ,
300: mtl_lot_numbers lot,
301: hr_operating_units hou

Line 426: --RLNAGARA B5018797 org_id is there in the po_headers_all table and hence getting from there.

422:
423:
424: -- Bug 4165704 - org_id should be in rcv_transactions table, but since it isn't
425: -- I need to get the value here
426: --RLNAGARA B5018797 org_id is there in the po_headers_all table and hence getting from there.
427: -- Here we are getting vendor name instead of vendor_site_code.
428: CURSOR get_vendor_no
429: IS /* 4576699*/
430: SELECT a.segment1