[Home] [Help]
151: AND (aida2.accounting_date between l_start_date and l_end_date)
152: AND aida2.posted_flag = 'Y'
153: AND aida2.line_type_lookup_code <> 'REC_TAX'
154: )
155: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
156: WHERE rt.transaction_id = aida.rcv_transaction_id
157: AND rae.rcv_transaction_id = rt.transaction_id
158: AND rae.event_type_id = 1 -- RECEIVE
159: AND rae.trx_flow_header_id is not NULL)
199: START WITH rt2.transaction_id = aida.rcv_transaction_id
200: CONNECT BY
201: prior rt2.transaction_id = rt2.parent_transaction_id
202: )
203: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
204: WHERE rt.transaction_id = aida.rcv_transaction_id
205: AND rae.rcv_transaction_id = rt.transaction_id
206: AND rae.event_type_id = 1 -- RECEIVE
207: AND rae.trx_flow_header_id is not NULL)
232: where aida.invoice_id = i_invoice_no
233: and i_invoice_no IS NOT NULL
234: and aida.rcv_transaction_id IS NOT NULL
235: and aida.line_type_lookup_code = 'ITEM'
236: and NOT EXISTS (SELECT 1 FROM rcv_transactions rt,rcv_accounting_events rae --add for dropshipment
237: WHERE rt.transaction_id = aida.rcv_transaction_id
238: AND rae.rcv_transaction_id = rt.transaction_id
239: AND rae.event_type_id = 1 -- RECEIVE
240: AND rae.trx_flow_header_id is not NULL)
367:
368: l_accounting_event_id NUMBER;
369: l_rae_unit_price NUMBER;
370: l_sob_id NUMBER;
371: l_rae_trf_price_flag rcv_accounting_events.INTERCOMPANY_PRICING_OPTION%TYPE;
372:
373: l_order_type_lookup_code VARCHAR2(20);
374:
375: CST_FAIL_GET_NQR EXCEPTION;
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
1500: and craca.rcv_transaction_id = c_rec.rcv_transaction_id
1501: and craca.cost_type_id = i_cost_type_id );
1502:
1503: l_stmt_num := 1120;
1504: Delete from rcv_accounting_events rae
1505: WHERE rae.event_type_id IN (18,19,20)
1506: AND rae.rcv_transaction_id = c_rec.rcv_transaction_id
1507: AND rae.event_source_id IN ( select header_id from cst_rcv_acq_costs_adj craca
1508: where craca.rcv_transaction_id = c_rec.rcv_transaction_id
1733: i_login_id);
1734: l_stmt_num := 1240;
1735: /* Insert PAC LCM ADJUST RECEIVE INTO RAE */
1736: IF (c_rec.po_distribution_id <> -1) THEN
1737: INSERT into RCV_ACCOUNTING_EVENTS(
1738: accounting_event_id,
1739: last_update_date,
1740: last_updated_by,
1741: last_update_login,
1814: 1
1815: FROM DUAL);
1816: ELSE
1817: l_stmt_num := 1245;
1818: INSERT into RCV_ACCOUNTING_EVENTS(
1819: accounting_event_id,
1820: last_update_date,
1821: last_updated_by,
1822: last_update_login,
1902: c_rec.organization_id ) LOOP
1903: IF (C_REC2.asset_inventory = 1
1904: AND C_REC.inventory_asset_flag ='Y' ) THEN
1905: l_stmt_num := 1250;
1906: INSERT into RCV_ACCOUNTING_EVENTS(
1907: accounting_event_id,
1908: last_update_date,
1909: last_updated_by,
1910: last_update_login,
2158: WHERE functional_area_id = 5)
2159: );
2160: END IF;
2161: l_stmt_num := 1320;
2162: INSERT into RCV_ACCOUNTING_EVENTS(
2163: accounting_event_id,
2164: last_update_date,
2165: last_updated_by,
2166: last_update_login,
2410: INTERCOMPANY_PRICING_OPTION
2411: Into l_accounting_event_id,
2412: l_rae_unit_price,
2413: l_rae_trf_price_flag
2414: From rcv_accounting_events rae,
2415: po_lines_all POL,
2416: po_line_locations_all POLL, -- Added for Complex work Procurement
2417: po_distributions_all POD
2418: Where rae.rcv_transaction_id = c_rec.transaction_id
4842: organization_id
4843: Into
4844: l_trx_flow,
4845: l_org_id
4846: From rcv_accounting_events rae,
4847: po_lines_all POL,
4848: po_distributions_all POD
4849: Where rae.rcv_transaction_id = i_rcv_txn_id
4850: And rae.event_type_id = 1 -- RECEIVE
4869: INTO
4870: l_po_rate
4871: FROM
4872: rcv_receiving_sub_ledger rsl,
4873: rcv_accounting_events rae
4874: WHERE
4875: rsl.rcv_transaction_id = i_rcv_txn_id AND
4876: rsl.accounted_cr is not null AND
4877: rsl.accounted_cr <> 0 and