DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on PO_LINES

Line 401: , po_lines pol

397: , NULL secondary_uom_code --OPM Convergence
398: , pol.secondary_qty secondary_quantity --OPM Convergence
399: FROM po_headers poh
400: , po_line_locations poll
401: , po_lines pol
402: , po_releases por
403: , mtl_system_items msi
404: , mtl_units_of_measure mum
405: , po_distributions pod

Line 1019: , po_lines pol

1015: , NULL secondary_uom_code --OPM Convergence
1016: , pol.secondary_qty secondary_quantity --OPM Convergence
1017: FROM po_headers poh
1018: , po_line_locations poll
1019: , po_lines pol
1020: , po_releases por
1021: , mtl_system_items msi
1022: , mtl_units_of_measure mum
1023: , po_distributions pod

Line 3150: , po_lines pol

3146: FROM rcv_shipment_lines rsl
3147: , rcv_shipment_headers rsh
3148: , po_headers poh
3149: , po_line_locations poll
3150: , po_lines pol
3151: , po_releases por
3152: , mtl_system_items msi
3153: , mtl_units_of_measure mum
3154: , po_distributions pod

Line 4039: FROM po_lines_all pola

4035: AND msi.organization_id = p_organization_id
4036: AND wlpn.lpn_id = wlpnc.parent_lpn_id
4037: AND (
4038: wlpnc.source_line_id IN(SELECT pola.po_line_id
4039: FROM po_lines_all pola
4040: WHERE pola.po_header_id = NVL(p_po_header_id, pola.po_header_id))
4041: OR wlpnc.source_line_id IS NULL
4042: )) lpnc
4043: WHERE lpnc.inventory_item_id = mln.inventory_item_id(+)