DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_SYSTEM_PARAMETERS

Line 2476: , po_system_parameters posp

2472: 'CLOSED FOR RECEIVING'),
2473: 'CLOSED FOR RECEIVING', 'CLOSED FOR RECEIVING',
2474: 'OPEN')))
2475: FROM po_distributions pod
2476: , po_system_parameters posp
2477: WHERE poll.line_location_id = l_id_tbl(i)
2478: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2479: AND pod.line_location_id = poll.line_location_id
2480: GROUP BY poll.quantity

Line 2588: , po_system_parameters posp

2584: 'CLOSED', 'CLOSED FOR INVOICE',
2585: 'CLOSED FOR RECEIVING', 'OPEN',
2586: poll.closed_code)))
2587: FROM po_distributions pod
2588: , po_system_parameters posp
2589: WHERE poll.line_location_id = l_id_tbl(i)
2590: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2591: AND pod.line_location_id = poll.line_location_id
2592: GROUP BY poll.quantity

Line 2692: , po_system_parameters posp

2688: 'CLOSED', 'CLOSED FOR RECEIVING',
2689: 'CLOSED FOR INVOICE', 'OPEN',
2690: poll.closed_code)))
2691: FROM po_distributions pod
2692: , po_system_parameters posp
2693: WHERE poll.line_location_id = l_id_tbl(i)
2694: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2695: AND pod.line_location_id = poll.line_location_id
2696: GROUP BY poll.quantity