DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on PO_DISTRIBUTIONS

Line 405: , po_distributions pod

401: , po_lines pol
402: , po_releases por
403: , mtl_system_items msi
404: , mtl_units_of_measure mum
405: , po_distributions pod
406: WHERE pod.po_distribution_id = v_po_distribution_id
407: AND poh.po_header_id = poll.po_header_id
408: AND pol.po_line_id = poll.po_line_id
409: AND poll.po_release_id = por.po_release_id(+)

Line 1023: , po_distributions pod

1019: , po_lines pol
1020: , po_releases por
1021: , mtl_system_items msi
1022: , mtl_units_of_measure mum
1023: , po_distributions pod
1024: WHERE pod.po_distribution_id = v_po_distribution_id
1025: AND poh.po_header_id = poll.po_header_id
1026: AND pol.po_line_id = poll.po_line_id
1027: AND poll.po_release_id = por.po_release_id(+)

Line 3258: , po_distributions pod

3254: , po_lines pol
3255: , po_releases por
3256: , mtl_system_items msi
3257: , mtl_units_of_measure mum
3258: , po_distributions pod
3259: WHERE pod.po_distribution_id = v_po_distribution_id
3260: AND pod.line_location_id = poll.line_location_id
3261: AND NVL(poll.approved_flag, 'N') = 'Y'
3262: AND NVL(poll.cancel_flag, 'N') = 'N'