[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;
394: l_stmt_num := 70;
395:
396: SELECT POD.destination_type_code
397: INTO l_destination_type_code
398: FROM po_distributions_all POD, rcv_transactions RT
399: WHERE POD.po_distribution_id = RT.po_distribution_id
400: AND RT.transaction_id = rec_txn.transaction_id;
401:
402: IF l_sLog THEN
490: 'P',NVL(NVL(POD.rate,POH.rate),1)) *
491: (RT.source_doc_quantity/RT.primary_quantity)))
492: INTO l_txn_price
493: FROM rcv_transactions RT,
494: po_distributions_all POD,
495: po_line_locations_all PLL,
496: po_headers_all POH
497: WHERE RT.transaction_id = rec_txn.transaction_id
498: AND POD.po_distribution_id = RT.po_distribution_id
511: NVL(SUM(PO_TAX_SV.get_tax('PO', POD.PO_DISTRIBUTION_ID)), 0)
512: INTO
513: l_tax
514: from
515: po_distributions_all pod,
516: po_line_locations_all pol,
517: rcv_transactions rt
518: where
519: rt.transaction_id = rec_txn.transaction_id
1053: BEGIN
1054: l_accrueOnRcptFlg := 'Y';
1055: -- Obtain Accrue on Receipt flag and destination type from POD
1056:
1057: /* MOAC Uptake - Replaced po_distributions with po_distributions_all as the view
1058: would be obsoleted in R12 */
1059:
1060: l_stmt_num := 10;
1061: select nvl(accrue_on_receipt_flag,'N'),
1061: select nvl(accrue_on_receipt_flag,'N'),
1062: destination_type_code
1063: into l_accrueOnRcptFlg,
1064: l_destTypeCode
1065: from po_distributions_all
1066: where po_distribution_id = p_po_distribution_id;
1067:
1068: -- Check if accrue on receipt, else return 0
1069: l_stmt_num := 20;