APPS.CSTPLVCP dependencies on CST_QUANTITY_LAYERS

Line 807: FROM cst_quantity_layers cql

803: UPDATE mtl_material_transactions mmt
804: SET TRANSFER_PRIOR_COSTED_QUANTITY =
805: (SELECT
806: layer_quantity
807: FROM cst_quantity_layers cql
808: WHERE cql.layer_id = i_txfr_layer_id)
809: WHERE mmt.transaction_id = i_txn_id
810: AND EXISTS (
811: SELECT 'X'

Line 812: FROM cst_quantity_layers cql

808: WHERE cql.layer_id = i_txfr_layer_id)
809: WHERE mmt.transaction_id = i_txn_id
810: AND EXISTS (
811: SELECT 'X'
812: FROM cst_quantity_layers cql
813: WHERE cql.layer_id = i_txfr_layer_id);
814:
815: -- item cost history
816: l_stmt_num := 20;

Line 1242: FROM cst_quantity_layers cql

1238: UPDATE mtl_material_transactions mmt
1239: SET TRANSFER_PRIOR_COSTED_QUANTITY =
1240: (SELECT
1241: layer_quantity
1242: FROM cst_quantity_layers cql
1243: WHERE cql.organization_id = l_which_org
1244: AND cql.inventory_item_id = i_item_id
1245: AND cql.cost_group_id = l_which_cst_grp)
1246: WHERE mmt.transaction_id = i_txn_id

Line 1249: FROM cst_quantity_layers cql

1245: AND cql.cost_group_id = l_which_cst_grp)
1246: WHERE mmt.transaction_id = i_txn_id
1247: AND EXISTS (
1248: SELECT 'X'
1249: FROM cst_quantity_layers cql
1250: WHERE cql.organization_id = l_which_org
1251: AND cql.inventory_item_id = i_item_id
1252: AND cql.cost_group_id = l_which_cst_grp);
1253:

Line 1291: select nvl(layer_id,0) into l_to_layer from cst_quantity_layers

1287: if ((i_txn_action_id = 3 and o_txn_qty > 0)
1288: OR (i_txn_action_id = 12 and i_org_id = i_txn_org_id and i_fob_point = 2)
1289: OR (i_txn_action_id = 21 and i_org_id = i_txfr_org_id and i_fob_point = 1)) then
1290: if (l_to_method <> 1) then
1291: select nvl(layer_id,0) into l_to_layer from cst_quantity_layers
1292: where organization_id = l_to_org and inventory_item_id = i_item_id
1293: and cost_group_id = l_to_cost_grp;
1294: end if;
1295:

Line 1341: from cst_quantity_layers

1337: OR (i_txn_action_id = 21 and i_org_id = i_txn_org_id and i_fob_point = 1)) then
1338: if (l_from_method <> 1) then
1339: select nvl(layer_id,0)
1340: into l_from_layer
1341: from cst_quantity_layers
1342: where organization_id = l_from_org
1343: and inventory_item_id = i_item_id
1344: and cost_group_id = l_from_cost_grp;
1345: end if;

Line 1715: from cst_quantity_layers

1711: l_stmt_num :=120;
1712: if ((o_exp_flag = 1) and (l_mclacd_exists = 0)) then
1713: select item_cost, layer_id
1714: into l_snd_txn_cost, l_from_layer_id
1715: from cst_quantity_layers
1716: where organization_id = l_from_org
1717: and inventory_item_id = i_item_id
1718: and cost_group_id = l_from_cost_grp;
1719:

Line 1890: select nvl(layer_id,0) into l_to_layer from cst_quantity_layers

1886: -- Also, the second argument was changed from i_txn_id to
1887: -- l_txn_update_id
1888:
1889: if (i_txn_action_id = 3) then
1890: select nvl(layer_id,0) into l_to_layer from cst_quantity_layers
1891: where organization_id = l_to_org and inventory_item_id = i_item_id
1892: and cost_group_id = l_to_cost_grp;
1893: end if;
1894:

Line 4465: FROM cst_quantity_layers cql

4461: UPDATE mtl_material_transactions mmt
4462: SET TRANSFER_PRIOR_COSTED_QUANTITY =
4463: (SELECT
4464: layer_quantity
4465: FROM cst_quantity_layers cql
4466: WHERE cql.organization_id = l_which_org
4467: AND cql.inventory_item_id = i_item_id
4468: AND cql.cost_group_id = l_which_cst_grp)
4469: WHERE mmt.transaction_id = i_txn_id

Line 4472: FROM cst_quantity_layers cql

4468: AND cql.cost_group_id = l_which_cst_grp)
4469: WHERE mmt.transaction_id = i_txn_id
4470: AND EXISTS (
4471: SELECT 'X'
4472: FROM cst_quantity_layers cql
4473: WHERE cql.organization_id = l_which_org
4474: AND cql.inventory_item_id = i_item_id
4475: AND cql.cost_group_id = l_which_cst_grp);
4476:

Line 4553: from cst_quantity_layers

4549:
4550: if (l_from_method <> 1) then
4551: select item_cost, layer_id
4552: into l_snd_txn_cost, l_from_layer
4553: from cst_quantity_layers
4554: where organization_id = l_from_org
4555: and inventory_item_id = i_item_id
4556: and cost_group_id = l_from_cost_grp;
4557: end if;

Line 4680: from cst_quantity_layers

4676:
4677: if (l_to_method <> 1) then
4678: select nvl(layer_id,0)
4679: into l_to_layer
4680: from cst_quantity_layers
4681: where organization_id = l_to_org
4682: and inventory_item_id = i_item_id
4683: and cost_group_id = l_to_cost_grp;
4684: end if;