[Home] [Help]
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;
177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;
179: l_rcv_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
180: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
181: l_lcm_flag PO_LINE_LOCATIONS_ALL.lcm_flag%TYPE;
182:
183: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
184: l_module constant varchar2(60) := 'po.plsql.'||l_full_name;
402: l_stmt_num := 70;
403:
404: SELECT POD.destination_type_code
405: INTO l_destination_type_code
406: FROM po_distributions_all POD, rcv_transactions RT
407: WHERE POD.po_distribution_id = RT.po_distribution_id
408: AND RT.transaction_id = rec_txn.transaction_id;
409:
410: IF l_sLog THEN
592: 'P',NVL(NVL(POD.rate,POH.rate),1)) *
593: (RT.source_doc_quantity/RT.primary_quantity)))
594: INTO l_txn_price
595: FROM rcv_transactions RT,
596: po_distributions_all POD,
597: po_line_locations_all PLL,
598: po_headers_all POH
599: WHERE RT.transaction_id = rec_txn.transaction_id
600: AND POD.po_distribution_id = RT.po_distribution_id
613: NVL(SUM(PO_TAX_SV.get_tax('PO', POD.PO_DISTRIBUTION_ID)), 0)
614: INTO
615: l_tax
616: from
617: po_distributions_all pod,
618: po_line_locations_all pol,
619: rcv_transactions rt
620: where
621: rt.transaction_id = rec_txn.transaction_id
1158: BEGIN
1159: l_accrueOnRcptFlg := 'Y';
1160: -- Obtain Accrue on Receipt flag and destination type from POD
1161:
1162: /* MOAC Uptake - Replaced po_distributions with po_distributions_all as the view
1163: would be obsoleted in R12 */
1164:
1165: l_stmt_num := 10;
1166: select nvl(accrue_on_receipt_flag,'N'),
1166: select nvl(accrue_on_receipt_flag,'N'),
1167: destination_type_code
1168: into l_accrueOnRcptFlg,
1169: l_destTypeCode
1170: from po_distributions_all
1171: where po_distribution_id = p_po_distribution_id;
1172:
1173: -- Check if accrue on receipt, else return 0
1174: l_stmt_num := 20;