[Home] [Help]
111: from ap_invoice_distributions_all aida
112: where aida.invoice_id = i_invoice_no
113: and aida.rcv_transaction_id IS NOT NULL
114: and aida.line_type_lookup_code = 'ITEM'
115: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
116: WHERE rt.transaction_id = aida.rcv_transaction_id
117: AND rae.rcv_transaction_id = rt.transaction_id
118: AND rae.event_type_id = 1 -- RECEIVE
119: AND rae.trx_flow_header_id is not NULL)
198: )
199: /* Invoice Lines Project
200: Removing reference to ap_chrg_allocations_all
201: */
202: AND NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
203: WHERE rt.transaction_id = aida.rcv_transaction_id
204: AND rae.rcv_transaction_id = rt.transaction_id
205: AND rae.event_type_id = 1 -- RECEIVE
206: AND rae.trx_flow_header_id is not NULL)
243: START WITH rt2.transaction_id = aida.rcv_transaction_id
244: CONNECT BY
245: prior rt2.transaction_id = rt2.parent_transaction_id
246: )
247: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
248: WHERE rt.transaction_id = aida.rcv_transaction_id
249: AND rae.rcv_transaction_id = rt.transaction_id
250: AND rae.event_type_id = 1 -- RECEIVE
251: AND rae.trx_flow_header_id is not NULL);
361:
362: l_accounting_event_id NUMBER;
363: l_rae_unit_price NUMBER;
364: l_sob_id NUMBER;
365: l_rae_trf_price_flag rcv_accounting_events.INTERCOMPANY_PRICING_OPTION%TYPE;
366:
367: l_order_type_lookup_code VARCHAR2(20);
368:
369: -- FP BUG 8355614 performance fix variables
617: INTERCOMPANY_PRICING_OPTION
618: Into l_accounting_event_id,
619: l_rae_unit_price,
620: l_rae_trf_price_flag
621: From rcv_accounting_events rae,
622: po_lines_all POL,
623: po_line_locations_all POLL, -- Added for Complex work Procurement
624: po_distributions_all POD
625: Where rae.rcv_transaction_id = c_rec.transaction_id
1507: and craca.rcv_transaction_id = c_rec.rcv_transaction_id
1508: and craca.cost_type_id = i_cost_type_id );
1509:
1510: l_stmt_num := 1120;
1511: Delete from rcv_accounting_events rae
1512: WHERE rae.event_type_id IN (18,19,20)
1513: AND rae.rcv_transaction_id = c_rec.rcv_transaction_id
1514: AND rae.event_source_id IN ( select header_id from cst_rcv_acq_costs_adj craca
1515: where craca.rcv_transaction_id = c_rec.rcv_transaction_id
1740: i_login_id);
1741: l_stmt_num := 1240;
1742: /* Insert PAC LCM ADJUST RECEIVE INTO RAE */
1743: IF (c_rec.po_distribution_id <> -1) THEN
1744: INSERT into RCV_ACCOUNTING_EVENTS(
1745: accounting_event_id,
1746: last_update_date,
1747: last_updated_by,
1748: last_update_login,
1821: 1
1822: FROM DUAL);
1823: ELSE
1824: l_stmt_num := 1245;
1825: INSERT into RCV_ACCOUNTING_EVENTS(
1826: accounting_event_id,
1827: last_update_date,
1828: last_updated_by,
1829: last_update_login,
1909: c_rec.organization_id ) LOOP
1910: IF (C_REC2.asset_inventory = 1
1911: AND C_REC.inventory_asset_flag ='Y' ) THEN
1912: l_stmt_num := 1250;
1913: INSERT into RCV_ACCOUNTING_EVENTS(
1914: accounting_event_id,
1915: last_update_date,
1916: last_updated_by,
1917: last_update_login,
2165: WHERE functional_area_id = 5)
2166: );
2167: END IF;
2168: l_stmt_num := 1320;
2169: INSERT into RCV_ACCOUNTING_EVENTS(
2170: accounting_event_id,
2171: last_update_date,
2172: last_updated_by,
2173: last_update_login,
2458: INTERCOMPANY_PRICING_OPTION
2459: Into l_accounting_event_id,
2460: l_rae_unit_price,
2461: l_rae_trf_price_flag
2462: From rcv_accounting_events rae,
2463: po_lines_all POL,
2464: po_line_locations_all POLL, -- Added for Complex work Procurement
2465: po_distributions_all POD
2466: Where rae.rcv_transaction_id = l_rec_transaction_id
4956: BUG 9495449
4957: In Global Procuremnt scenario,currency conversion is not
4958: happening when matched to receipt. Created fucntion
4959: get_rcv_rate ,such that it will consider the rate from
4960: Rcv_accounting_events for event_type_id=1(receipt)
4961: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
4962:
4963: FUNCTION get_rcv_rate (i_rcv_txn_id IN NUMBER)
4964: RETURN NUMBER
4996: organization_id
4997: Into
4998: l_trx_flow,
4999: l_org_id
5000: From rcv_accounting_events rae/*,
5001: po_lines_all POL,
5002: po_distributions_all POD*/
5003: Where rae.rcv_transaction_id = i_rcv_txn_id
5004: And rae.event_type_id = 1 -- RECEIVE
5026: INTO
5027: l_rcv_rate
5028: FROM
5029: rcv_receiving_sub_ledger rsl,
5030: rcv_accounting_events rae
5031: WHERE
5032: rsl.rcv_transaction_id = i_rcv_txn_id AND
5033: rsl.accounted_cr is not null AND
5034: rsl.accounted_cr <> 0 and
5040: MAX(NVL(currency_conversion_rate, 1))
5041: INTO
5042: l_rcv_rate
5043: FROM
5044: rcv_accounting_events
5045: WHERE
5046: rcv_transaction_id = i_rcv_txn_id AND
5047: event_type_id = 1 AND
5048: organization_id = l_org_id;
5141: organization_id
5142: Into
5143: l_trx_flow,
5144: l_org_id
5145: From rcv_accounting_events rae/*,
5146: po_lines_all POL,
5147: po_distributions_all POD*/
5148: Where rae.rcv_transaction_id = i_rcv_txn_id
5149: And rae.event_type_id = 1 -- RECEIVE
5169: MAX(NVL(currency_conversion_rate, 1))
5170: INTO
5171: l_po_rate
5172: FROM
5173: rcv_accounting_events
5174: WHERE
5175: rcv_transaction_id = i_rcv_txn_id AND
5176: event_type_id = 1 AND
5177: organization_id = l_org_id;
5181: INTO
5182: l_po_rate
5183: FROM
5184: rcv_receiving_sub_ledger rsl,
5185: rcv_accounting_events rae
5186: WHERE
5187: rsl.rcv_transaction_id = i_rcv_txn_id AND
5188: rsl.accounted_cr is not null AND
5189: rsl.accounted_cr <> 0 and