APPS.CSTPAPBR dependencies on CST_PAC_ITEM_COSTS

Line 2873: FROM CST_PAC_ITEM_COSTS CPIC

2869: l_stmt_num := 110;
2870:
2871: SELECT NVL(CPIC.item_cost,0)
2872: INTO l_pacp_pwac_cost
2873: FROM CST_PAC_ITEM_COSTS CPIC
2874: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
2875: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
2876: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
2877:

Line 2954: FROM CST_PAC_ITEM_COSTS CPIC

2950: /* Get prior period PWAC Cost */
2951: BEGIN
2952: SELECT nvl(CPIC.item_cost,0)
2953: INTO l_prev_period_pwac_cost
2954: FROM CST_PAC_ITEM_COSTS CPIC
2955: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
2956: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
2957: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
2958: EXCEPTION

Line 3290: FROM CST_PAC_ITEM_COSTS CPIC

3286: l_stmt_num := 185;
3287:
3288: SELECT NVL(CPIC.item_cost,0)
3289: INTO l_pwac_cost
3290: FROM CST_PAC_ITEM_COSTS CPIC
3291: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
3292: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
3293: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
3294:

Line 3689: FROM CST_PAC_ITEM_COSTS CPIC

3685: l_stmt_num := 270;
3686:
3687: SELECT NVL(CPIC.item_cost,0)
3688: INTO l_pacp_pwac_cost
3689: FROM CST_PAC_ITEM_COSTS CPIC
3690: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
3691: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
3692: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
3693:

Line 3805: FROM CST_PAC_ITEM_COSTS CPIC

3801: /* Get prior period PWAC Cost */
3802: BEGIN
3803: SELECT nvl(CPIC.item_cost,0)
3804: INTO l_prev_period_pwac_cost
3805: FROM CST_PAC_ITEM_COSTS CPIC
3806: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
3807: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
3808: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
3809: EXCEPTION

Line 4083: FROM CST_PAC_ITEM_COSTS CPIC

4079: l_stmt_num := 336;
4080:
4081: SELECT NVL(CPIC.item_cost,0)
4082: INTO l_pwac_cost
4083: FROM CST_PAC_ITEM_COSTS CPIC
4084: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
4085: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
4086: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
4087:

Line 4969: FROM CST_PAC_ITEM_COSTS CPIC

4965:
4966: /* Use CPIC cost */
4967: SELECT sum(NVL(CPIC.item_cost,0))
4968: INTO l_pacp_pwac_cost
4969: FROM CST_PAC_ITEM_COSTS CPIC
4970: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
4971: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
4972: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
4973:

Line 5080: FROM CST_PAC_ITEM_COSTS CPIC

5076: /* Get prior period PWAC Cost */
5077: BEGIN
5078: SELECT nvl(CPIC.item_cost,0)
5079: INTO l_prev_period_pwac_cost
5080: FROM CST_PAC_ITEM_COSTS CPIC
5081: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
5082: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
5083: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
5084: EXCEPTION

Line 5892: FROM CST_PAC_ITEM_COSTS CPIC

5888: l_stmt_num := 680;
5889:
5890: SELECT NVL(CPIC.item_cost,0)
5891: INTO l_pwac_cost
5892: FROM CST_PAC_ITEM_COSTS CPIC
5893: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
5894: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
5895: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
5896:

Line 9915: FROM CST_PAC_ITEM_COSTS CPIC

9911: /* Debit Expense account of the Logical Exp Req receipt at PWAC */
9912:
9913: SELECT NVL(CPIC.item_cost,0)
9914: INTO l_pwac_cost
9915: FROM CST_PAC_ITEM_COSTS CPIC
9916: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
9917: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
9918: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
9919:

Line 10429: FROM CST_PAC_ITEM_COSTS CPIC

10425: l_stmt_num := 530;
10426:
10427: SELECT NVL(CPIC.item_cost,0)
10428: INTO l_pwac_cost
10429: FROM CST_PAC_ITEM_COSTS CPIC
10430: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10431: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
10432: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
10433:

Line 10781: FROM CST_PAC_ITEM_COSTS CPIC

10777: IF (i_ae_txn_rec.txn_action_id = 17) THEN /* Logical Exp Req Rcpt, Take sending Cost Group Cost */
10778: l_stmt_num := 160;
10779: SELECT NVL(CPIC.item_cost,0)
10780: INTO o_pacp_pwac_cost
10781: FROM CST_PAC_ITEM_COSTS CPIC
10782: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10783: AND CPIC.COST_GROUP_ID = l_txfr_cost_group_id
10784: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
10785: ELSE

Line 10789: FROM CST_PAC_ITEM_COSTS CPIC

10785: ELSE
10786: l_stmt_num := 165;
10787: SELECT NVL(CPIC.item_cost,0)
10788: INTO o_pacp_pwac_cost
10789: FROM CST_PAC_ITEM_COSTS CPIC
10790: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10791: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
10792: AND CPIC.PAC_PERIOD_ID = i_ae_txn_rec.accounting_period_id;
10793: END IF;

Line 10822: FROM CST_PAC_ITEM_COSTS CPIC

10818: l_stmt_num := 180;
10819: BEGIN
10820: SELECT nvl(CPIC.item_cost,0)
10821: INTO o_prev_period_pwac_cost
10822: FROM CST_PAC_ITEM_COSTS CPIC
10823: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10824: AND CPIC.COST_GROUP_ID = l_txfr_cost_group_id
10825: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
10826: EXCEPTION

Line 10836: FROM CST_PAC_ITEM_COSTS CPIC

10832: l_stmt_num := 190;
10833: BEGIN
10834: SELECT nvl(CPIC.item_cost,0)
10835: INTO o_prev_period_pwac_cost
10836: FROM CST_PAC_ITEM_COSTS CPIC
10837: WHERE CPIC.INVENTORY_ITEM_ID = i_ae_txn_rec.inventory_item_id
10838: AND CPIC.COST_GROUP_ID = i_ae_txn_rec.cost_group_id
10839: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
10840: EXCEPTION