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.CSTPAVCP dependencies on CST_QUANTITY_LAYERS

Line 909: cst_quantity_layers cql,

905: 0
906: )
907: )
908: FROM mtl_cst_txn_cost_details ctcd,
909: cst_quantity_layers cql,
910: cst_layer_cost_details clcd
911: WHERE ctcd.transaction_id = i_txn_id
912: AND ctcd.organization_id = i_org_id
913: AND cql.layer_id = i_layer_id

Line 1024: Update cst_quantity_layers cql

1020: ** Update cst_quanity_layers **
1021: ********************************************************************/
1022: l_stmt_num := 50;
1023: /* Used the Base Table instead of View Bug 4773025 */
1024: Update cst_quantity_layers cql
1025: Set (last_updated_by,
1026: last_update_date,
1027: last_update_login,
1028: request_id,

Line 1130: FROM cst_quantity_layers

1126: l_mandatory_update := 0;
1127:
1128: SELECT count(*)
1129: INTO l_num_cost_groups
1130: FROM cst_quantity_layers
1131: WHERE inventory_item_id = i_item_id
1132: AND organization_id = i_org_id;
1133:
1134: IF (l_num_cost_groups = 1) THEN

Line 1137: FROM cst_quantity_layers

1133:
1134: IF (l_num_cost_groups = 1) THEN
1135: SELECT layer_quantity
1136: INTO l_layer_quantity
1137: FROM cst_quantity_layers
1138: WHERE inventory_item_id = i_item_id
1139: AND organization_id = i_org_id;
1140:
1141: IF (l_layer_quantity = 0) THEN

Line 2043: FROM cst_quantity_layers cql

2039: UPDATE mtl_material_transactions mmt
2040: SET TRANSFER_PRIOR_COSTED_QUANTITY =
2041: (SELECT
2042: layer_quantity
2043: FROM cst_quantity_layers cql
2044: WHERE cql.layer_id = l_layer_id)
2045: WHERE mmt.transaction_id = i_txn_id
2046: AND EXISTS (
2047: SELECT 'X'

Line 2048: FROM cst_quantity_layers cql

2044: WHERE cql.layer_id = l_layer_id)
2045: WHERE mmt.transaction_id = i_txn_id
2046: AND EXISTS (
2047: SELECT 'X'
2048: FROM cst_quantity_layers cql
2049: WHERE cql.layer_id = l_layer_id);
2050:
2051: -- item cost history
2052: l_stmt_num := 10;

Line 3430: from cst_quantity_layers cql

3426: l_stmt_num := 20;
3427:
3428: select layer_quantity
3429: into l_cur_onhand
3430: from cst_quantity_layers cql
3431: where cql.layer_id = i_layer_id;
3432:
3433: l_new_onhand := l_cur_onhand + i_txn_qty;
3434:

Line 3581: Update cst_quantity_layers cql

3577: ** Update layer quantity and layer costs information **
3578: ********************************************************************/
3579: l_stmt_num := 60;
3580: /* Used the Base Table instead of View Bug 4773025 */
3581: Update cst_quantity_layers cql
3582: Set (last_updated_by,
3583: last_update_date,
3584: last_update_login,
3585: request_id,

Line 3757: Update layer quantity information in cst_quantity_layers.

3753: end if;
3754: end if;
3755:
3756: /********************************************************************
3757: ** Update layer quantity information in cst_quantity_layers. **
3758: ** There is no need to update the layer quantity for the **
3759: ** following transactions: **
3760: ** 1) wip scrap transactions **
3761: ** 2) Expense flag = 1 **

Line 3770: Update cst_quantity_layers cql

3766: else
3767:
3768: l_stmt_num := 10;
3769:
3770: Update cst_quantity_layers cql
3771: set last_update_date = sysdate,
3772: last_updated_by = i_user_id,
3773: last_update_login = i_login_id,
3774: request_id = i_req_id,

Line 3891: from cst_quantity_layers cql

3887: l_stmt_num := 10;
3888:
3889: Select layer_quantity
3890: into layer_qty
3891: from cst_quantity_layers cql
3892: where cql.layer_id = i_layer_id;
3893:
3894: l_stmt_num := 20;
3895:

Line 4010: FROM cst_quantity_layers cql,

4006: l_stmt_num := 44;
4007: UPDATE mtl_material_transactions mmt
4008: SET prior_costed_quantity = (
4009: SELECT cql.layer_quantity - mmt.primary_quantity
4010: FROM cst_quantity_layers cql,
4011: mtl_parameters mp
4012: WHERE cql.organization_id = i_org_id
4013: AND cql.inventory_item_id = l_item_id
4014: AND cql.cost_group_id = mp.default_cost_group_id

Line 4020: FROM cst_quantity_layers cql,

4016: )
4017: WHERE mmt.transaction_id = i_txn_id
4018: AND EXISTS (
4019: SELECT 'X'
4020: FROM cst_quantity_layers cql,
4021: mtl_parameters mp
4022: WHERE cql.organization_id = i_org_id
4023: AND cql.inventory_item_id = l_item_id
4024: AND cql.cost_group_id = mp.default_cost_group_id

Line 4079: FROM cst_quantity_layers cql

4075: UPDATE mtl_material_transactions mmt
4076: SET prior_costed_quantity =
4077: (SELECT
4078: layer_quantity
4079: FROM cst_quantity_layers cql
4080: WHERE cql.organization_id = i_org_id
4081: AND cql.inventory_item_id = l_item_id
4082: AND cql.cost_group_id = l_transfer_cost_grp_id)
4083: WHERE mmt.transaction_id = l_transfer_txn_id

Line 4086: FROM cst_quantity_layers cql

4082: AND cql.cost_group_id = l_transfer_cost_grp_id)
4083: WHERE mmt.transaction_id = l_transfer_txn_id
4084: AND EXISTS (
4085: SELECT 'X'
4086: FROM cst_quantity_layers cql
4087: WHERE cql.organization_id = i_org_id
4088: AND cql.inventory_item_id = l_item_id
4089: AND cql.cost_group_id = l_transfer_cost_grp_id);
4090:

Line 4181: from cst_quantity_layers cql

4177:
4178: -- Bug 4905189, added the calculation for total_value
4179: select nvl(sum(layer_quantity),0), nvl(sum(layer_quantity*nvl(item_cost,0)),0)
4180: into total_qty, total_value
4181: from cst_quantity_layers cql
4182: where cql.inventory_item_id = i_item_id
4183: and cql.organization_id = i_org_id;
4184:
4185: -- If total quantity is <= 0 and the mandatory_update flag is not set,

Line 4256: cst_quantity_layers cql

4252: i_prg_id,
4253: sysdate,
4254: decode(clcd.cost_element_id,2,l_default_MOH_subelement,NULL) --------------Bug 3959770
4255: from cst_layer_cost_details clcd,
4256: cst_quantity_layers cql
4257: where cql.organization_id = i_org_id
4258: and cql.inventory_item_id = i_item_id
4259: and cql.layer_id = clcd.layer_id
4260: group by cost_element_id, level_type;

Line 4656: FROM cst_quantity_layers cql

4652: UPDATE mtl_material_transactions mmt
4653: SET TRANSFER_PRIOR_COSTED_QUANTITY =
4654: (SELECT
4655: layer_quantity
4656: FROM cst_quantity_layers cql
4657: WHERE cql.organization_id = l_which_org
4658: AND cql.inventory_item_id = i_item_id
4659: AND cql.cost_group_id = l_which_cst_grp)
4660: WHERE mmt.transaction_id = i_txn_id

Line 4663: FROM cst_quantity_layers cql

4659: AND cql.cost_group_id = l_which_cst_grp)
4660: WHERE mmt.transaction_id = i_txn_id
4661: AND EXISTS (
4662: SELECT 'X'
4663: FROM cst_quantity_layers cql
4664: WHERE cql.organization_id = l_which_org
4665: AND cql.inventory_item_id = i_item_id
4666: AND cql.cost_group_id = l_which_cst_grp);
4667:

Line 5100: from cst_quantity_layers

5096: fnd_file.put_line(fnd_file.log, '>>>Hook not used');
5097: END IF;
5098: select item_cost, layer_id
5099: into l_snd_txn_cost, l_from_layer_id
5100: from cst_quantity_layers
5101: where organization_id = l_from_org
5102: and inventory_item_id = i_item_id
5103: and cost_group_id = l_from_cost_grp;
5104: END IF;

Line 5112: from cst_quantity_layers

5108: END IF;
5109:
5110: select item_cost, layer_id
5111: into l_snd_txn_cost, l_from_layer_id
5112: from cst_quantity_layers
5113: where organization_id = l_from_org
5114: and inventory_item_id = i_item_id
5115: and cost_group_id = l_from_cost_grp;
5116: END IF;

Line 8925: FROM cst_quantity_layers cql

8921: UPDATE mtl_material_transactions mmt
8922: SET TRANSFER_PRIOR_COSTED_QUANTITY =
8923: (SELECT
8924: layer_quantity
8925: FROM cst_quantity_layers cql
8926: WHERE cql.organization_id = l_which_org
8927: AND cql.inventory_item_id = i_item_id
8928: AND cql.cost_group_id = l_which_cst_grp)
8929: WHERE mmt.transaction_id = i_txn_id

Line 8932: FROM cst_quantity_layers cql

8928: AND cql.cost_group_id = l_which_cst_grp)
8929: WHERE mmt.transaction_id = i_txn_id
8930: AND EXISTS (
8931: SELECT 'X'
8932: FROM cst_quantity_layers cql
8933: WHERE cql.organization_id = l_which_org
8934: AND cql.inventory_item_id = i_item_id
8935: AND cql.cost_group_id = l_which_cst_grp);
8936:

Line 9002: from cst_quantity_layers

8998:
8999: l_stmt_num := 40;
9000: select item_cost, layer_id
9001: into l_snd_txn_cost, l_from_layer_id
9002: from cst_quantity_layers
9003: where organization_id = l_from_org
9004: and inventory_item_id = i_item_id
9005: and cost_group_id = l_from_cost_grp;
9006: