APPS.CSTPLVCP dependencies on CST_INV_LAYERS

Line 547: FROM cst_inv_layers

543: SYSDATE
544: FROM cst_inv_layer_cost_details CILCD
545: WHERE CILCD.inv_layer_id = (
546: SELECT MIN(inv_layer_id)
547: FROM cst_inv_layers
548: WHERE layer_id = l_layer_id
549: AND layer_quantity > 0
550: AND creation_date = (
551: SELECT MIN(creation_date)

Line 552: FROM cst_inv_layers

548: WHERE layer_id = l_layer_id
549: AND layer_quantity > 0
550: AND creation_date = (
551: SELECT MIN(creation_date)
552: FROM cst_inv_layers
553: WHERE layer_id = l_layer_id
554: AND layer_quantity > 0
555: )
556: );

Line 3190: from cst_inv_layers

3186: -- or if the cost method is FIFO or LIFO
3187:
3188: select nvl(max(inv_layer_id), 0)
3189: into l_inv_layer_id
3190: from cst_inv_layers
3191: where layer_id = l_from_layer;
3192:
3193: if l_debug = 'Y' then
3194: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)

Line 3366: SELECT cst_inv_layers_s.nextval

3362:
3363: if(l_exp_item = 0) then /*BUG 12397424 do this only for asset items*/
3364: if(l_inv_layer_id = 0) then
3365: l_stmt_num := 86;
3366: SELECT cst_inv_layers_s.nextval
3367: INTO l_inv_layer_id
3368: FROM dual;
3369: l_stmt_num :=87;
3370: SELECT transaction_source_id

Line 3378: INTO cst_inv_layers (

3374: l_stmt_num :=88;
3375: l_src_number := CSTPLENG.GET_SOURCE_NUMBER(i_txn_id,i_txn_src_type,l_src_id);
3376: l_stmt_num :=89;
3377: INSERT
3378: INTO cst_inv_layers (
3379: layer_id,
3380: inv_layer_id,
3381: organization_id,
3382: inventory_item_id,