[Home] [Help]
5:
6:
7: /*============================================================================+
8: | This procedure is called by the Accounting Package for the Accounting Lib. |
9: | It first gets the details of the transaction from RCV_TRANSACTIONS |
10: | for the txn that is being processed. The appropriate procedure is then |
11: | called to create the accounting entry lines in the form of a PL/SQL table |
12: | |
13: | Logic : |
11: | called to create the accounting entry lines in the form of a PL/SQL table |
12: | |
13: | Logic : |
14: | |
15: | For the transaction passed in, get the txn details from RCV_TRANSACTIONS |
16: | If the current txn is period end accrual txn , call create_per_end_ae_lines |
17: | If the current txn is accrual txn, call create_rcv_ae_lines |
18: | Period End Accrual : |
19: | If current transaction is not receive or match, return |
164: INTO
165: l_po_line_count
166: FROM
167: po_lines_all pol,
168: rcv_transactions rt
169: WHERE
170: pol.po_line_id = rt.po_line_id AND
171: rt.transaction_id = i_transaction_id;
172:
249: l_ae_txn_rec.exp_item ,
250: l_ae_txn_rec.line_id,
251: l_ae_txn_rec.lcm_flag
252: FROM
253: rcv_transactions rt,
254: po_lines_all pol,
255: po_line_locations_all poll -- Added for Complex work procurement
256: WHERE
257: rt.po_line_id = pol.po_line_id
340: INTO
341: l_po_line_count
342: FROM
343: po_lines_all pol,
344: rcv_transactions rt,
345: rcv_accounting_events rae
346: WHERE
347: pol.po_line_id = rt.po_line_id AND
348: rt.transaction_id = rae.rcv_transaction_id AND
998: rt6.transaction_id
999: INTO
1000: l_par_rcv_txn
1001: FROM
1002: rcv_transactions rt6
1003: WHERE
1004: rt6.transaction_type in (l_receive,l_match)
1005: START WITH
1006: rt6.transaction_id = i_ae_txn_rec.transaction_id
1103: l_acq_cost_ent_po
1104: from
1105: cst_rcv_acq_cost_details cracd,
1106: po_line_locations_all poll,
1107: rcv_transactions rt
1108: where
1109: poll.line_location_id = cracd.po_line_location_id
1110: and cracd.header_id = (select header_id
1111: from cst_rcv_acq_costs crac
1178: INTO
1179: l_par_txn,
1180: l_par_txn_type
1181: FROM
1182: rcv_transactions rt1
1183: WHERE
1184: rt1.transaction_id = (select rt2.parent_transaction_id
1185: FROM
1186: rcv_transactions rt2
1182: rcv_transactions rt1
1183: WHERE
1184: rt1.transaction_id = (select rt2.parent_transaction_id
1185: FROM
1186: rcv_transactions rt2
1187: WHERE
1188: rt2.transaction_id = i_ae_txn_rec.transaction_id);
1189:
1190: END IF;
1259: l_doc_id,
1260: l_dropship_type_code,
1261: l_uom_ratio
1262: FROM
1263: rcv_transactions rt
1264: WHERE
1265: rt.transaction_id = i_ae_txn_rec.transaction_id;
1266:
1267: IF l_debug_flag = 'Y' THEN
1376: -----------------------------------------------------------------------------------------
1377: INTO
1378: l_po_price
1379: FROM
1380: rcv_transactions rt,
1381: po_line_locations_all poll
1382: WHERE
1383: rt.transaction_id = i_ae_txn_rec.transaction_id
1384: AND rt.po_line_location_id = poll.line_location_id;
1737: select org_id
1738: into l_po_ou_id /* Get the OU where PO is created */
1739: from po_headers_all
1740: where po_header_id = (select po_header_id
1741: from rcv_transactions
1742: where transaction_id = i_ae_txn_rec.transaction_id);
1743:
1744: l_stmt_num := 751;
1745:
2478: poll.price_override * rt.source_doc_quantity / rt.primary_quantity)
2479: INTO
2480: l_po_price
2481: FROM
2482: rcv_transactions rt,
2483: po_line_locations_all poll
2484: WHERE
2485: rt.transaction_id = i_ae_txn_rec.transaction_id
2486: AND rt.po_line_location_id = poll.line_location_id;
2848: po_headers_all POH,
2849: po_lines_all POL,
2850: po_line_locations_all POLL,
2851: po_distributions_all POD,
2852: rcv_transactions RT
2853: WHERE
2854: POH.po_header_id = POD.po_header_id AND
2855: POL.po_line_id = POD.po_line_id AND
2856: POLL.line_location_id = POD.line_location_id AND
2885: po_headers_all POH,
2886: po_lines_all POL,
2887: po_line_locations_all POLL,
2888: po_distributions_all POD,
2889: rcv_transactions RT
2890: WHERE
2891: POH.po_header_id = POD.po_header_id
2892: AND POL.po_line_id = POD.po_line_id
2893: AND POLL.line_location_id = POD.line_location_id
3475: INTO
3476: l_doc_level,
3477: l_doc_id
3478: FROM
3479: rcv_transactions rt
3480: WHERE
3481: rt.transaction_id = i_ae_txn_rec.transaction_id;
3482:
3483: IF l_debug_flag = 'Y' THEN
3824: l_operating_unit
3825: FROM
3826: po_headers_all
3827: WHERE
3828: po_header_id = (select po_header_id from rcv_transactions
3829: where transaction_id = i_transaction_id);
3830:
3831:
3832: l_stmt_num := 30;
4110: -- End of Bug 3588765
4111: ----------------------------------------------------------------------------
4112: rt4.parent_transaction_id
4113: FROM
4114: rcv_transactions rt4
4115: -- J Changes -------------------------------------------------------------
4116: -- Bug 3588765 --
4117: -- PO_LINES_ALL POL
4118: -- End of Bug 3588765
4132: prior rt4.transaction_id = rt4.parent_transaction_id
4133: AND rt4.po_line_location_id = PRIOR rt4.po_line_location_id; -- Change for the bug 4968702
4134:
4135: l_nqd NUMBER := 0;
4136: l_parent_type rcv_transactions.transaction_type%TYPE;
4137: l_stmt_num NUMBER := 0;
4138: -- Bug 3588765 --
4139: l_primary_quantity NUMBER := 0;
4140: -- End of Bug 3588765
4152: SELECT DECODE(POLL1.MATCHING_BASIS, -- Changed for Complex work procurement
4153: 'AMOUNT', rt6.AMOUNT,
4154: 'QUANTITY', RT6.PRIMARY_QUANTITY) "PRIMARY_QUANTITY"
4155: INTO l_primary_quantity
4156: FROM rcv_transactions rt6,
4157: PO_LINE_LOCATIONS_ALL POLL1 -- Changed for Complex work procurement
4158: WHERE rt6.transaction_id=c_nqd_rec.transaction_id
4159: AND RT6.PO_LINE_LOCATION_ID= POLL1.LINE_LOCATION_ID; -- Changed for Complex work procurement
4160: -- End of Bug 3588765 ----------------------
4171: rt5.transaction_type
4172: INTO
4173: l_parent_type
4174: FROM
4175: rcv_transactions rt5
4176: WHERE
4177: rt5.transaction_id = c_nqd_rec.parent_transaction_id;
4178: END IF;
4179: ------------------------------------------------------------