APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_SYSTEM_PARAMETERS

Line 2636: , po_system_parameters posp

2632: 'CLOSED FOR RECEIVING'),
2633: 'CLOSED FOR RECEIVING', 'CLOSED FOR RECEIVING',
2634: 'OPEN')))
2635: FROM po_distributions pod
2636: , po_system_parameters posp
2637: WHERE poll.line_location_id = l_id_tbl(i)
2638: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2639: AND pod.line_location_id = poll.line_location_id
2640: GROUP BY poll.quantity

Line 2751: , po_system_parameters posp

2747: 'CLOSED FOR RECEIVING'),
2748: 'CLOSED FOR RECEIVING', 'CLOSED FOR RECEIVING',
2749: 'OPEN')))
2750: FROM po_distributions pod
2751: , po_system_parameters posp
2752: WHERE poll.line_location_id = l_id_tbl(i)
2753: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2754: AND pod.line_location_id = poll.line_location_id
2755: GROUP BY poll.quantity

Line 2874: , po_system_parameters posp

2870: 'CLOSED','CLOSED FOR INVOICE')),'N','CLOSED FOR INVOICE'), -- Bug 11730977 end
2871: 'CLOSED FOR RECEIVING', 'OPEN',
2872: poll.closed_code)))
2873: FROM po_distributions pod
2874: , po_system_parameters posp
2875: WHERE poll.line_location_id = l_id_tbl(i)
2876: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2877: AND pod.line_location_id = poll.line_location_id
2878: GROUP BY poll.quantity

Line 2982: , po_system_parameters posp

2978: 'CLOSED', 'CLOSED FOR RECEIVING',
2979: 'CLOSED FOR INVOICE', 'OPEN',
2980: poll.closed_code)))
2981: FROM po_distributions pod
2982: , po_system_parameters posp
2983: WHERE poll.line_location_id = l_id_tbl(i)
2984: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2985: AND pod.line_location_id = poll.line_location_id
2986: GROUP BY poll.quantity