APPS.GMF_RCV_ACCOUNTING_PKG dependencies on MTL_PARAMETERS

Line 2294: FROM mtl_parameters mp

2290: l_stmt_num := 60;
2291:
2292: SELECT cost_of_sales_account
2293: INTO l_ic_coss_acct_id
2294: FROM mtl_parameters mp
2295: WHERE mp.organization_id = p_rcv_accttxn.organization_id;
2296:
2297: l_stmt_num := 70;
2298: get_hookaccount

Line 2395: FROM mtl_parameters mp

2391: l_stmt_num := 90;
2392:
2393: SELECT cost_of_sales_account
2394: INTO l_ic_coss_acct_id
2395: FROM mtl_parameters mp
2396: WHERE mp.organization_id = p_rcv_accttxn.organization_id;
2397:
2398: l_stmt_num := 100;
2399: get_hookaccount

Line 8479: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE; /* INVCONV ANTHIYAG Bug#5529309 18-Sep-2006 */

8475: l_trx_flow_header_id NUMBER := NULL;
8476: l_drop_ship_flag NUMBER := NULL;
8477: l_opm_flag NUMBER;
8478: l_cr_flag BOOLEAN;
8479: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE; /* INVCONV ANTHIYAG Bug#5529309 18-Sep-2006 */
8480:
8481: -- Cursor to get all parent receive transactions
8482: -- for a given po_header or po_release
8483: CURSOR c_parent_receive_txns_csr

Line 8486: FROM rcv_transactions a, mtl_parameters b

8482: -- for a given po_header or po_release
8483: CURSOR c_parent_receive_txns_csr
8484: IS
8485: SELECT a.transaction_id, a.organization_id
8486: FROM rcv_transactions a, mtl_parameters b
8487: WHERE (
8488: (a.transaction_type = 'RECEIVE' AND a.parent_transaction_id = -1)
8489: OR
8490: a.transaction_type = 'MATCH'

Line 8504: FROM rcv_transactions a, mtl_parameters b

8500: -- a parent receive transaction.
8501: CURSOR c_deliver_txns_csr (l_par_txn IN NUMBER)
8502: IS
8503: SELECT a.transaction_id, a.po_distribution_id
8504: FROM rcv_transactions a, mtl_parameters b
8505: WHERE a.transaction_type = 'DELIVER'
8506: AND a.organization_id = b.organization_id
8507: AND NVL(b.process_enabled_flag, 'N') = 'Y'
8508: AND a.parent_transaction_id = l_par_txn;

Line 8529: mtl_parameters b

8525: BEGIN
8526: SELECT nvl(b.process_enabled_flag, 'N')
8527: INTO l_process_enabled_flag
8528: FROM po_line_locations_all a,
8529: mtl_parameters b
8530: WHERE a.line_location_id = p_po_line_location_id
8531: AND b.organization_id = a.ship_to_organization_id;
8532: EXCEPTION
8533: WHEN OTHERS THEN