APPS.CSTPLVCP dependencies on CST_QUANTITY_LAYERS

Line 741: FROM cst_quantity_layers cql

737: UPDATE mtl_material_transactions mmt
738: SET TRANSFER_PRIOR_COSTED_QUANTITY =
739: (SELECT
740: layer_quantity
741: FROM cst_quantity_layers cql
742: WHERE cql.layer_id = i_txfr_layer_id)
743: WHERE mmt.transaction_id = i_txn_id
744: AND EXISTS (
745: SELECT 'X'

Line 746: FROM cst_quantity_layers cql

742: WHERE cql.layer_id = i_txfr_layer_id)
743: WHERE mmt.transaction_id = i_txn_id
744: AND EXISTS (
745: SELECT 'X'
746: FROM cst_quantity_layers cql
747: WHERE cql.layer_id = i_txfr_layer_id);
748:
749: -- item cost history
750: l_stmt_num := 20;

Line 1176: FROM cst_quantity_layers cql

1172: UPDATE mtl_material_transactions mmt
1173: SET TRANSFER_PRIOR_COSTED_QUANTITY =
1174: (SELECT
1175: layer_quantity
1176: FROM cst_quantity_layers cql
1177: WHERE cql.organization_id = l_which_org
1178: AND cql.inventory_item_id = i_item_id
1179: AND cql.cost_group_id = l_which_cst_grp)
1180: WHERE mmt.transaction_id = i_txn_id

Line 1183: FROM cst_quantity_layers cql

1179: AND cql.cost_group_id = l_which_cst_grp)
1180: WHERE mmt.transaction_id = i_txn_id
1181: AND EXISTS (
1182: SELECT 'X'
1183: FROM cst_quantity_layers cql
1184: WHERE cql.organization_id = l_which_org
1185: AND cql.inventory_item_id = i_item_id
1186: AND cql.cost_group_id = l_which_cst_grp);
1187:

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

1221: if ((i_txn_action_id = 3 and o_txn_qty > 0)
1222: OR (i_txn_action_id = 12 and i_org_id = i_txn_org_id and i_fob_point = 2)
1223: OR (i_txn_action_id = 21 and i_org_id = i_txfr_org_id and i_fob_point = 1)) then
1224: if (l_to_method <> 1) then
1225: select nvl(layer_id,0) into l_to_layer from cst_quantity_layers
1226: where organization_id = l_to_org and inventory_item_id = i_item_id
1227: and cost_group_id = l_to_cost_grp;
1228: end if;
1229:

Line 1275: from cst_quantity_layers

1271: OR (i_txn_action_id = 21 and i_org_id = i_txn_org_id and i_fob_point = 1)) then
1272: if (l_from_method <> 1) then
1273: select nvl(layer_id,0)
1274: into l_from_layer
1275: from cst_quantity_layers
1276: where organization_id = l_from_org
1277: and inventory_item_id = i_item_id
1278: and cost_group_id = l_from_cost_grp;
1279: end if;

Line 1649: from cst_quantity_layers

1645: l_stmt_num :=120;
1646: if ((o_exp_flag = 1) and (l_mclacd_exists = 0)) then
1647: select item_cost, layer_id
1648: into l_snd_txn_cost, l_from_layer_id
1649: from cst_quantity_layers
1650: where organization_id = l_from_org
1651: and inventory_item_id = i_item_id
1652: and cost_group_id = l_from_cost_grp;
1653:

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

1820: -- Also, the second argument was changed from i_txn_id to
1821: -- l_txn_update_id
1822:
1823: if (i_txn_action_id = 3) then
1824: select nvl(layer_id,0) into l_to_layer from cst_quantity_layers
1825: where organization_id = l_to_org and inventory_item_id = i_item_id
1826: and cost_group_id = l_to_cost_grp;
1827: end if;
1828:

Line 4398: FROM cst_quantity_layers cql

4394: UPDATE mtl_material_transactions mmt
4395: SET TRANSFER_PRIOR_COSTED_QUANTITY =
4396: (SELECT
4397: layer_quantity
4398: FROM cst_quantity_layers cql
4399: WHERE cql.organization_id = l_which_org
4400: AND cql.inventory_item_id = i_item_id
4401: AND cql.cost_group_id = l_which_cst_grp)
4402: WHERE mmt.transaction_id = i_txn_id

Line 4405: FROM cst_quantity_layers cql

4401: AND cql.cost_group_id = l_which_cst_grp)
4402: WHERE mmt.transaction_id = i_txn_id
4403: AND EXISTS (
4404: SELECT 'X'
4405: FROM cst_quantity_layers cql
4406: WHERE cql.organization_id = l_which_org
4407: AND cql.inventory_item_id = i_item_id
4408: AND cql.cost_group_id = l_which_cst_grp);
4409:

Line 4486: from cst_quantity_layers

4482:
4483: if (l_from_method <> 1) then
4484: select item_cost, layer_id
4485: into l_snd_txn_cost, l_from_layer
4486: from cst_quantity_layers
4487: where organization_id = l_from_org
4488: and inventory_item_id = i_item_id
4489: and cost_group_id = l_from_cost_grp;
4490: end if;

Line 4613: from cst_quantity_layers

4609:
4610: if (l_to_method <> 1) then
4611: select nvl(layer_id,0)
4612: into l_to_layer
4613: from cst_quantity_layers
4614: where organization_id = l_to_org
4615: and inventory_item_id = i_item_id
4616: and cost_group_id = l_to_cost_grp;
4617: end if;