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 978: cst_quantity_layers cql,

974: 0
975: )
976: )
977: FROM mtl_cst_txn_cost_details ctcd,
978: cst_quantity_layers cql,
979: cst_layer_cost_details clcd
980: WHERE ctcd.transaction_id = i_txn_id
981: AND ctcd.organization_id = i_org_id
982: AND cql.layer_id = i_layer_id

Line 1172: Update cst_quantity_layers cql

1168: ** Update cst_quanity_layers **
1169: ********************************************************************/
1170: l_stmt_num := 50;
1171: /* Used the Base Table instead of View Bug 4773025 */
1172: Update cst_quantity_layers cql
1173: Set (last_updated_by,
1174: last_update_date,
1175: last_update_login,
1176: request_id,

Line 1278: FROM cst_quantity_layers

1274: l_mandatory_update := 0;
1275: /* Bug10324713
1276: SELECT count(*)
1277: INTO l_num_cost_groups
1278: FROM cst_quantity_layers
1279: WHERE inventory_item_id = i_item_id
1280: AND organization_id = i_org_id;
1281:
1282: IF (l_num_cost_groups = 1) THEN

Line 1285: FROM cst_quantity_layers

1281:
1282: IF (l_num_cost_groups = 1) THEN
1283: SELECT layer_quantity
1284: INTO l_layer_quantity
1285: FROM cst_quantity_layers
1286: WHERE inventory_item_id = i_item_id
1287: AND organization_id = i_org_id;
1288:
1289: IF (l_layer_quantity = 0) THEN

Line 2200: FROM cst_quantity_layers cql

2196: UPDATE mtl_material_transactions mmt
2197: SET TRANSFER_PRIOR_COSTED_QUANTITY =
2198: (SELECT
2199: layer_quantity
2200: FROM cst_quantity_layers cql
2201: WHERE cql.layer_id = i_txfr_layer_id) /* Modified for bug 6635134 */
2202: WHERE mmt.transaction_id = i_txn_id
2203: AND EXISTS (
2204: SELECT 'X'

Line 2205: FROM cst_quantity_layers cql

2201: WHERE cql.layer_id = i_txfr_layer_id) /* Modified for bug 6635134 */
2202: WHERE mmt.transaction_id = i_txn_id
2203: AND EXISTS (
2204: SELECT 'X'
2205: FROM cst_quantity_layers cql
2206: WHERE cql.layer_id = i_txfr_layer_id); /* Modified for bug 6635134 */
2207:
2208: -- item cost history
2209: l_stmt_num := 10;

Line 3601: from cst_quantity_layers cql

3597: l_stmt_num := 20;
3598:
3599: select layer_quantity
3600: into l_cur_onhand
3601: from cst_quantity_layers cql
3602: where cql.layer_id = i_layer_id;
3603:
3604: l_new_onhand := l_cur_onhand + i_txn_qty;
3605:

Line 3752: Update cst_quantity_layers cql

3748: ** Update layer quantity and layer costs information **
3749: ********************************************************************/
3750: l_stmt_num := 60;
3751: /* Used the Base Table instead of View Bug 4773025 */
3752: Update cst_quantity_layers cql
3753: Set (last_updated_by,
3754: last_update_date,
3755: last_update_login,
3756: request_id,

Line 3928: Update layer quantity information in cst_quantity_layers.

3924: end if;
3925: end if;
3926:
3927: /********************************************************************
3928: ** Update layer quantity information in cst_quantity_layers. **
3929: ** There is no need to update the layer quantity for the **
3930: ** following transactions: **
3931: ** 1) wip scrap transactions **
3932: ** 2) Expense flag = 1 **

Line 3941: Update cst_quantity_layers cql

3937: else
3938:
3939: l_stmt_num := 10;
3940:
3941: Update cst_quantity_layers cql
3942: set last_update_date = sysdate,
3943: last_updated_by = i_user_id,
3944: last_update_login = i_login_id,
3945: request_id = i_req_id,

Line 4062: from cst_quantity_layers cql

4058: l_stmt_num := 10;
4059:
4060: Select layer_quantity
4061: into layer_qty
4062: from cst_quantity_layers cql
4063: where cql.layer_id = i_layer_id;
4064:
4065: l_stmt_num := 20;
4066:

Line 4182: FROM cst_quantity_layers cql,

4178: l_stmt_num := 44;
4179: UPDATE mtl_material_transactions mmt
4180: SET prior_costed_quantity = (
4181: SELECT cql.layer_quantity - mmt.primary_quantity
4182: FROM cst_quantity_layers cql,
4183: mtl_parameters mp
4184: WHERE cql.organization_id = i_org_id
4185: AND cql.inventory_item_id = l_item_id
4186: AND cql.cost_group_id = mp.default_cost_group_id

Line 4192: FROM cst_quantity_layers cql,

4188: )
4189: WHERE mmt.transaction_id = i_txn_id
4190: AND EXISTS (
4191: SELECT 'X'
4192: FROM cst_quantity_layers cql,
4193: mtl_parameters mp
4194: WHERE cql.organization_id = i_org_id
4195: AND cql.inventory_item_id = l_item_id
4196: AND cql.cost_group_id = mp.default_cost_group_id

Line 4251: FROM cst_quantity_layers cql

4247: UPDATE mtl_material_transactions mmt
4248: SET prior_costed_quantity =
4249: (SELECT
4250: layer_quantity
4251: FROM cst_quantity_layers cql
4252: WHERE cql.organization_id = i_org_id
4253: AND cql.inventory_item_id = l_item_id
4254: AND cql.cost_group_id = l_transfer_cost_grp_id)
4255: WHERE mmt.transaction_id = l_transfer_txn_id

Line 4258: FROM cst_quantity_layers cql

4254: AND cql.cost_group_id = l_transfer_cost_grp_id)
4255: WHERE mmt.transaction_id = l_transfer_txn_id
4256: AND EXISTS (
4257: SELECT 'X'
4258: FROM cst_quantity_layers cql
4259: WHERE cql.organization_id = i_org_id
4260: AND cql.inventory_item_id = l_item_id
4261: AND cql.cost_group_id = l_transfer_cost_grp_id);
4262:

Line 4354: from cst_quantity_layers cql

4350:
4351: -- Bug 4905189, added the calculation for total_value
4352: select nvl(sum(layer_quantity),0), nvl(sum(layer_quantity*nvl(item_cost,0)),0),count(1)
4353: into total_qty, total_value,l_num_cost_groups
4354: from cst_quantity_layers cql
4355: where cql.inventory_item_id = i_item_id
4356: and cql.organization_id = i_org_id;
4357:
4358: -- If total quantity is <= 0 and the mandatory_update flag is not set,

Line 4431: cst_quantity_layers cql

4427: decode(clcd.cost_element_id,2,decode(clcd.level_type,1,l_default_MOH_subelement,
4428: NULL),
4429: NULL)
4430: from cst_layer_cost_details clcd,
4431: cst_quantity_layers cql
4432: where cql.organization_id = i_org_id
4433: and cql.inventory_item_id = i_item_id
4434: and cql.layer_id = clcd.layer_id
4435: group by cost_element_id, level_type;

Line 4831: FROM cst_quantity_layers cql

4827: UPDATE mtl_material_transactions mmt
4828: SET TRANSFER_PRIOR_COSTED_QUANTITY =
4829: (SELECT
4830: layer_quantity
4831: FROM cst_quantity_layers cql
4832: WHERE cql.organization_id = l_which_org
4833: AND cql.inventory_item_id = i_item_id
4834: AND cql.cost_group_id = l_which_cst_grp)
4835: WHERE mmt.transaction_id = i_txn_id

Line 4838: FROM cst_quantity_layers cql

4834: AND cql.cost_group_id = l_which_cst_grp)
4835: WHERE mmt.transaction_id = i_txn_id
4836: AND EXISTS (
4837: SELECT 'X'
4838: FROM cst_quantity_layers cql
4839: WHERE cql.organization_id = l_which_org
4840: AND cql.inventory_item_id = i_item_id
4841: AND cql.cost_group_id = l_which_cst_grp);
4842:

Line 5275: from cst_quantity_layers

5271: fnd_file.put_line(fnd_file.log, '>>>Hook not used');
5272: END IF;
5273: select item_cost, layer_id
5274: into l_snd_txn_cost, l_from_layer_id
5275: from cst_quantity_layers
5276: where organization_id = l_from_org
5277: and inventory_item_id = i_item_id
5278: and cost_group_id = l_from_cost_grp;
5279: END IF;

Line 5287: from cst_quantity_layers

5283: END IF;
5284:
5285: select item_cost, layer_id
5286: into l_snd_txn_cost, l_from_layer_id
5287: from cst_quantity_layers
5288: where organization_id = l_from_org
5289: and inventory_item_id = i_item_id
5290: and cost_group_id = l_from_cost_grp;
5291: END IF;

Line 9122: FROM cst_quantity_layers cql

9118: UPDATE mtl_material_transactions mmt
9119: SET TRANSFER_PRIOR_COSTED_QUANTITY =
9120: (SELECT
9121: layer_quantity
9122: FROM cst_quantity_layers cql
9123: WHERE cql.organization_id = l_which_org
9124: AND cql.inventory_item_id = i_item_id
9125: AND cql.cost_group_id = l_which_cst_grp)
9126: WHERE mmt.transaction_id = i_txn_id

Line 9129: FROM cst_quantity_layers cql

9125: AND cql.cost_group_id = l_which_cst_grp)
9126: WHERE mmt.transaction_id = i_txn_id
9127: AND EXISTS (
9128: SELECT 'X'
9129: FROM cst_quantity_layers cql
9130: WHERE cql.organization_id = l_which_org
9131: AND cql.inventory_item_id = i_item_id
9132: AND cql.cost_group_id = l_which_cst_grp);
9133:

Line 9199: from cst_quantity_layers

9195:
9196: l_stmt_num := 40;
9197: select item_cost, layer_id
9198: into l_snd_txn_cost, l_from_layer_id
9199: from cst_quantity_layers
9200: where organization_id = l_from_org
9201: and inventory_item_id = i_item_id
9202: and cost_group_id = l_from_cost_grp;
9203: