APPS.CSTPAPBR dependencies on MTL_PARAMETERS

Line 1090: mtl_parameters

1086: encumbrance_reversal_flag
1087: into
1088: l_enc_rev
1089: from
1090: mtl_parameters
1091: where organization_id = i_ae_txn_rec.organization_id;
1092:
1093: IF g_debug_flag = 'Y' THEN
1094: fnd_file.put_line(fnd_file.log,'Organization_id : '||(i_ae_txn_rec.organization_id));

Line 1129: FROM MTL_PARAMETERS MP

1125: l_stmt_num := 80;
1126: /* Check if it is a transfer between Process and Discrete Orgs */
1127: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
1128: INTO l_pd_txfr_ind
1129: FROM MTL_PARAMETERS MP
1130: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
1131: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
1132: /* Get the expense sub or asset sub from the issue sub for logical exp req rcpt */
1133: SELECT decode(asset_inventory,1,0,1)

Line 2333: FROM MTL_PARAMETERS MP

2329: -- INVCONV sikhanna START
2330: l_stmt_num := 52;
2331: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
2332: INTO l_pd_txfr_ind
2333: FROM MTL_PARAMETERS MP
2334: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
2335: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
2336:
2337: /* Process-Discrete X-fers set the profile to 2 if ICR relations setup and in diff OU */

Line 3093: FROM MTL_PARAMETERS MP

3089: -- Processing the process-discrete txns
3090: -- INVCONV sikhanna
3091: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
3092: INTO l_pd_txfr_ind
3093: FROM MTL_PARAMETERS MP
3094: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
3095: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
3096:
3097:

Line 3985: FROM MTL_PARAMETERS MP

3981: -- INVCONV sikhanna
3982: l_stmt_num := 322;
3983: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
3984: INTO l_pd_txfr_ind
3985: FROM MTL_PARAMETERS MP
3986: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
3987: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
3988:
3989: l_stmt_num := 324;

Line 4336: FROM MTL_PARAMETERS MP

4332: -- INVCONV sikhanna START
4333: l_stmt_num := 372;
4334: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
4335: INTO l_pd_txfr_ind
4336: FROM MTL_PARAMETERS MP
4337: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
4338: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
4339:
4340: /* Process-Discrete X-fers set the profile to 2 if ICR relations setup and in diff OU */

Line 4741: FROM MTL_PARAMETERS MP

4737: -- Processing the process-discrete txns
4738: -- INVCONV sikhanna
4739: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
4740: INTO l_pd_txfr_ind
4741: FROM MTL_PARAMETERS MP
4742: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
4743: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
4744:
4745: IF g_debug_flag = 'Y' THEN

Line 5429: FROM MTL_PARAMETERS MP

5425: -- Processing the process-discrete txns
5426: -- INVCONV sikhanna
5427: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
5428: INTO l_pd_txfr_ind
5429: FROM MTL_PARAMETERS MP
5430: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
5431: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
5432:
5433: IF g_debug_flag = 'Y' THEN

Line 6711: mtl_parameters mp

6707:
6708: select nvl(msi.cost_of_sales_account, mp.cost_of_sales_account)
6709: into l_acct_rec.account
6710: from mtl_system_items msi,
6711: mtl_parameters mp
6712: where msi.organization_id = i_ae_txn_rec.organization_id
6713: and msi.inventory_item_id = i_ae_txn_rec.inventory_item_id
6714: and mp.organization_id = msi.organization_id;
6715:

Line 7085: from mtl_parameters b

7081: IF (l_std_cost_adj_var_acct = -1) THEN
7082: l_stmt_num := 47;
7083: select NVL(b.cost_of_sales_account,-1)
7084: into l_std_cost_adj_var_acct
7085: from mtl_parameters b
7086: where organization_id = i_ae_txn_rec.organization_id;
7087: END IF;
7088:
7089: l_ae_line_rec_std_var.account := l_std_cost_adj_var_acct;

Line 8840: mtl_parameters

8836: encumbrance_reversal_flag
8837: into
8838: l_enc_rev
8839: from
8840: mtl_parameters
8841: where organization_id = i_ae_txn_rec.organization_id;
8842:
8843: IF g_debug_flag = 'Y' THEN
8844: fnd_file.put_line(fnd_file.log,'Organization_id : '||(i_ae_txn_rec.organization_id));

Line 9451: FROM mtl_parameters mp

9447:
9448: l_stmt_num := 5;
9449: SELECT MOD(SUM(DECODE(MP.process_enabled_flag,'Y',1,2)), 2)
9450: INTO l_pd_txfr_ind
9451: FROM mtl_parameters mp
9452: WHERE mp.organization_id = i_ae_txn_rec.organization_id
9453: OR mp.organization_id = i_ae_txn_rec.xfer_organization_id;
9454:
9455: IF g_debug_flag = 'Y' THEN

Line 9615: FROM mtl_system_items MSI, mtl_parameters MP

9611: l_stmt_num := 90;
9612:
9613: SELECT nvl(MSI.cost_of_sales_account, MP.cost_of_sales_account)
9614: INTO l_cogs_ccid
9615: FROM mtl_system_items MSI, mtl_parameters MP
9616: WHERE MSI.organization_id = l_from_org
9617: AND MSI.inventory_item_id = i_ae_txn_rec.inventory_item_id
9618: AND MP.organization_id = MSI.organization_id;
9619:

Line 10013: FROM MTL_PARAMETERS MP

10009:
10010: /* Check if it is a transfer between Process and Discrete Orgs */
10011: SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
10012: INTO l_pd_txfr_ind
10013: FROM MTL_PARAMETERS MP
10014: WHERE MP.ORGANIZATION_ID = i_ae_txn_rec.xfer_organization_id
10015: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
10016:
10017: l_stmt_num := 190;

Line 10960: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,

10956: p_api_version IN NUMBER,
10957: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10958: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
10959: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
10960: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
10961: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10962: p_total_primary_qty IN NUMBER,
10963: x_encumbrance_amount OUT NOCOPY NUMBER,
10964: x_encumbrance_account OUT NOCOPY NUMBER,