APPS.PA_PO_INTEGRATION_UTILS dependencies on PO_DISTRIBUTIONS

Line 15: FUNCTION Allow_Project_Info_Change ( p_po_distribution_id IN po_distributions_all.po_distribution_id%type)

11: Return : 'Y', if project information on the purchase order distribution can be updated.
12: 'N', if project information on the purchase order distribution cannot be updated.
13: */
14:
15: FUNCTION Allow_Project_Info_Change ( p_po_distribution_id IN po_distributions_all.po_distribution_id%type)
16: RETURN varchar2 IS
17:
18: l_sum_amount_interfaced number := 0;
19: l_uninterfaced_to_pa number := 0;

Line 53: ,po_distributions_all podist/*Bug 3905697*/

49: FROM dual
50: WHERE EXISTS
51: (SELECT 1 FROM rcv_transactions rcv_txn,
52: rcv_receiving_sub_ledger rcv_sub
53: ,po_distributions_all podist/*Bug 3905697*/
54: where rcv_txn.po_distribution_id = l_po_distribution_id
55: and podist.po_distribution_id=rcv_txn.po_distribution_id/*Bug 3905697*/
56: and rcv_sub.code_combination_id = podist.code_combination_id/*Bug 3905697*/
57: and rcv_sub.rcv_transaction_id = rcv_txn.transaction_id

Line 90: ,po_distributions_all podist/*Bug 3905697*/

86: FROM dual
87: WHERE EXISTS
88: (SELECT 1 FROM rcv_transactions rcv_txn,
89: rcv_receiving_sub_ledger rcv_sub
90: ,po_distributions_all podist/*Bug 3905697*/
91: where rcv_txn.po_distribution_id = l_po_distribution_id
92: and podist.po_distribution_id=rcv_txn.po_distribution_id/*Bug 3905697*/
93: and rcv_sub.code_combination_id = podist.code_combination_id/*Bug 3905697*/
94: and rcv_sub.rcv_transaction_id = rcv_txn.transaction_id

Line 145: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */

141: p_rcv_transaction_id IN NUMBER,
142: p_po_distribution_id IN NUMBER,
143: p_accounting_event_id IN NUMBER)
144: IS
145: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */
146: l_po_distribution_id po_distributions_all.po_distribution_id%type;
147: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;
148: l_processed Number := 0;
149:

Line 146: l_po_distribution_id po_distributions_all.po_distribution_id%type;

142: p_po_distribution_id IN NUMBER,
143: p_accounting_event_id IN NUMBER)
144: IS
145: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */
146: l_po_distribution_id po_distributions_all.po_distribution_id%type;
147: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;
148: l_processed Number := 0;
149:
150: PROCEDURE net_zero_adj_po IS

Line 167: ,po_distributions podist

163: SELECT /*+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_txn.transaction_id /*4338075*/
164: ,rcv_txn.po_distribution_id
165: ,rcvsub.accounting_event_id -- pricing changes
166: FROM rcv_transactions rcv_txn
167: ,po_distributions podist
168: ,rcv_receiving_sub_ledger rcvsub
169: WHERE rcv_txn.transaction_id = rcvsub.rcv_transaction_id
170: AND rcv_txn.parent_transaction_id = (SELECT parent_transaction_id
171: FROM rcv_transactions rcv_txn3

Line 186: ,po_distributions podist2

182: ))
183: and 0 = (SELECT /*+ INDEX(RCV_TXN2 RCV_TRANSACTIONS_N1) */sum(nvl(rcvsub2.entered_dr,0)-nvl(rcvsub2.entered_cr,0))/*4338075*/
184: FROM rcv_transactions rcv_txn2
185: ,rcv_receiving_sub_ledger rcvsub2
186: ,po_distributions podist2
187: WHERE rcv_txn2.transaction_id = rcvsub2.rcv_transaction_id
188: and podist2.po_distribution_id = rcv_txn2.po_distribution_id
189: and podist2.code_combination_id = rcvsub2.code_combination_id
190: and rcvsub2.actual_flag = 'A'

Line 287: FROM po_distributions po_dist

283: )
284: OR
285: (EXISTS
286: (SELECT po_distribution_id
287: FROM po_distributions po_dist
288: WHERE po_dist.po_distribution_id = rcv_txn.po_distribution_id
289: AND ((rcv_txn.destination_type_code = 'EXPENSE' AND
290: po_dist.project_id IS NULL)
291: OR

Line 309: po_distributions_all po_dist1

305: ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
306: AND EXISTS (SELECT 'X'
307: FROM mtl_system_items si,
308: po_lines_all pol,
309: po_distributions_all po_dist1
310: WHERE po_dist1.po_line_id = pol.po_line_id
311: AND po_dist1.po_distribution_id = rcv_txn.po_distribution_id
312: AND si.inventory_item_id = pol.item_id
313: AND po_dist1.project_id IS NOT NULL

Line 330: FROM Rcv_Transactions rcv_txn, PO_Distributions po_dist

326: WHERE rcv_sub.pa_addition_flag IN ('N','I')
327: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
328: AND EXISTS
329: ( SELECT po_dist.code_combination_id
330: FROM Rcv_Transactions rcv_txn, PO_Distributions po_dist
331: WHERE
332: (
333: (rcv_txn.destination_type_code ='EXPENSE' )
334: OR (rcv_txn.destination_type_code = 'RECEIVING'