eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPAPBR dependencies on CST_PAC_ITEM_COSTS

Line 2591: FROM CST_PAC_ITEM_COSTS CPIC

2587: l_stmt_num := 110;
2588:
2589: SELECT NVL(CPIC.item_cost,0)
2590: INTO l_pacp_pwac_cost
2591: FROM CST_PAC_ITEM_COSTS CPIC
2592: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
2593: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
2594: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
2595:

Line 2672: FROM CST_PAC_ITEM_COSTS CPIC

2668: /* Get prior period PWAC Cost */
2669: BEGIN
2670: SELECT nvl(CPIC.item_cost,0)
2671: INTO l_prev_period_pwac_cost
2672: FROM CST_PAC_ITEM_COSTS CPIC
2673: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
2674: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
2675: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
2676: EXCEPTION

Line 3008: FROM CST_PAC_ITEM_COSTS CPIC

3004: l_stmt_num := 185;
3005:
3006: SELECT NVL(CPIC.item_cost,0)
3007: INTO l_pwac_cost
3008: FROM CST_PAC_ITEM_COSTS CPIC
3009: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
3010: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
3011: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
3012:

Line 3407: FROM CST_PAC_ITEM_COSTS CPIC

3403: l_stmt_num := 270;
3404:
3405: SELECT NVL(CPIC.item_cost,0)
3406: INTO l_pacp_pwac_cost
3407: FROM CST_PAC_ITEM_COSTS CPIC
3408: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
3409: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
3410: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
3411:

Line 3523: FROM CST_PAC_ITEM_COSTS CPIC

3519: /* Get prior period PWAC Cost */
3520: BEGIN
3521: SELECT nvl(CPIC.item_cost,0)
3522: INTO l_prev_period_pwac_cost
3523: FROM CST_PAC_ITEM_COSTS CPIC
3524: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
3525: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
3526: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
3527: EXCEPTION

Line 3801: FROM CST_PAC_ITEM_COSTS CPIC

3797: l_stmt_num := 336;
3798:
3799: SELECT NVL(CPIC.item_cost,0)
3800: INTO l_pwac_cost
3801: FROM CST_PAC_ITEM_COSTS CPIC
3802: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
3803: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
3804: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
3805:

Line 4687: FROM CST_PAC_ITEM_COSTS CPIC

4683:
4684: /* Use CPIC cost */
4685: SELECT sum(NVL(CPIC.item_cost,0))
4686: INTO l_pacp_pwac_cost
4687: FROM CST_PAC_ITEM_COSTS CPIC
4688: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
4689: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
4690: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
4691:

Line 4798: FROM CST_PAC_ITEM_COSTS CPIC

4794: /* Get prior period PWAC Cost */
4795: BEGIN
4796: SELECT nvl(CPIC.item_cost,0)
4797: INTO l_prev_period_pwac_cost
4798: FROM CST_PAC_ITEM_COSTS CPIC
4799: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
4800: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
4801: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
4802: EXCEPTION

Line 5610: FROM CST_PAC_ITEM_COSTS CPIC

5606: l_stmt_num := 680;
5607:
5608: SELECT NVL(CPIC.item_cost,0)
5609: INTO l_pwac_cost
5610: FROM CST_PAC_ITEM_COSTS CPIC
5611: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
5612: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
5613: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
5614:

Line 9462: FROM CST_PAC_ITEM_COSTS CPIC

9458: /* Debit Expense account of the Logical Exp Req receipt at PWAC */
9459:
9460: SELECT NVL(CPIC.item_cost,0)
9461: INTO l_pwac_cost
9462: FROM CST_PAC_ITEM_COSTS CPIC
9463: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
9464: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
9465: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
9466:

Line 9954: FROM CST_PAC_ITEM_COSTS CPIC

9950: l_stmt_num := 530;
9951:
9952: SELECT NVL(CPIC.item_cost,0)
9953: INTO l_pwac_cost
9954: FROM CST_PAC_ITEM_COSTS CPIC
9955: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
9956: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
9957: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
9958:

Line 10305: FROM CST_PAC_ITEM_COSTS CPIC

10301: o_pacp_flag := 1;
10302:
10303: SELECT NVL(CPIC.item_cost,0)
10304: INTO o_pacp_pwac_cost
10305: FROM CST_PAC_ITEM_COSTS CPIC
10306: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10307: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
10308: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
10309:

Line 10338: FROM CST_PAC_ITEM_COSTS CPIC

10334: l_stmt_num := 180;
10335: BEGIN
10336: SELECT nvl(CPIC.item_cost,0)
10337: INTO o_prev_period_pwac_cost
10338: FROM CST_PAC_ITEM_COSTS CPIC
10339: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10340: AND CPIC.COST_GROUP_ID = l_txfr_cost_group_id
10341: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
10342: EXCEPTION

Line 10352: FROM CST_PAC_ITEM_COSTS CPIC

10348: l_stmt_num := 190;
10349: BEGIN
10350: SELECT nvl(CPIC.item_cost,0)
10351: INTO o_prev_period_pwac_cost
10352: FROM CST_PAC_ITEM_COSTS CPIC
10353: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10354: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
10355: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
10356: EXCEPTION