APPS.CSTPAPBR dependencies on MTL_PARAMETERS

Line 898: mtl_parameters

894: encumbrance_reversal_flag
895: into
896: l_enc_rev
897: from
898: mtl_parameters
899: where organization_id = i_ae_txn_rec.organization_id;
900:
901: IF g_debug_flag = 'Y' THEN
902: fnd_file.put_line(fnd_file.log,'Organization_id : '||(i_ae_txn_rec.organization_id));

Line 2051: FROM MTL_PARAMETERS MP

2047: -- INVCONV sikhanna START
2048: l_stmt_num := 52;
2049: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
2050: INTO l_pd_txfr_ind
2051: FROM MTL_PARAMETERS MP
2052: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
2053: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
2054:
2055: /* Process-Discrete X-fers set the profile to 2 if ICR relations setup and in diff OU */

Line 2811: FROM MTL_PARAMETERS MP

2807: -- Processing the process-discrete txns
2808: -- INVCONV sikhanna
2809: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
2810: INTO l_pd_txfr_ind
2811: FROM MTL_PARAMETERS MP
2812: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
2813: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
2814:
2815:

Line 3703: FROM MTL_PARAMETERS MP

3699: -- INVCONV sikhanna
3700: l_stmt_num := 322;
3701: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
3702: INTO l_pd_txfr_ind
3703: FROM MTL_PARAMETERS MP
3704: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
3705: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
3706:
3707: l_stmt_num := 324;

Line 4054: FROM MTL_PARAMETERS MP

4050: -- INVCONV sikhanna START
4051: l_stmt_num := 372;
4052: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
4053: INTO l_pd_txfr_ind
4054: FROM MTL_PARAMETERS MP
4055: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
4056: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
4057:
4058: /* Process-Discrete X-fers set the profile to 2 if ICR relations setup and in diff OU */

Line 4459: FROM MTL_PARAMETERS MP

4455: -- Processing the process-discrete txns
4456: -- INVCONV sikhanna
4457: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
4458: INTO l_pd_txfr_ind
4459: FROM MTL_PARAMETERS MP
4460: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
4461: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
4462:
4463: IF g_debug_flag = 'Y' THEN

Line 5147: FROM MTL_PARAMETERS MP

5143: -- Processing the process-discrete txns
5144: -- INVCONV sikhanna
5145: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
5146: INTO l_pd_txfr_ind
5147: FROM MTL_PARAMETERS MP
5148: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
5149: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
5150:
5151: IF g_debug_flag = 'Y' THEN

Line 6407: mtl_parameters mp

6403:
6404: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
6405: into l_acct_rec.account
6406: from mtl_system_items msi,
6407: mtl_parameters mp
6408: where msi.organization_id = i_ae_txn_rec.organization_id
6409: and msi.inventory_item_id = i_ae_txn_rec.inventory_item_id
6410: and mp.organization_id = msi.organization_id;
6411:

Line 9010: FROM mtl_parameters mp

9006:
9007: l_stmt_num := 5;
9008: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)
9009: INTO l_pd_txfr_ind
9010: FROM mtl_parameters mp
9011: WHERE mp.organization_id = i_ae_txn_rec.organization_id
9012: OR mp.organization_id = i_ae_txn_rec.xfer_organization_id;
9013:
9014: IF g_debug_flag = 'Y' THEN

Line 9174: FROM mtl_system_items MSI, mtl_parameters MP

9170: l_stmt_num := 90;
9171:
9172: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
9173: INTO l_cogs_ccid
9174: FROM mtl_system_items MSI, mtl_parameters MP
9175: WHERE MSI.organization_id = l_from_org
9176: AND MSI.inventory_item_id = i_ae_txn_rec.inventory_item_id
9177: AND MP.organization_id = MSI.organization_id;
9178:

Line 9554: FROM MTL_PARAMETERS MP

9550:
9551: /* Check if it is a transfer between Process and Discrete Orgs */
9552: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
9553: INTO l_pd_txfr_ind
9554: FROM MTL_PARAMETERS MP
9555: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
9556: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
9557:
9558: l_stmt_num := 190;

Line 10476: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,

10472: p_api_version IN NUMBER,
10473: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10474: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
10475: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
10476: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
10477: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10478: p_total_primary_qty IN NUMBER,
10479: x_encumbrance_amount OUT NOCOPY NUMBER,
10480: x_encumbrance_account OUT NOCOPY NUMBER,