APPS.CSTPLVCP dependencies on CST_INV_LAYERS

Line 481: FROM cst_inv_layers

477: SYSDATE
478: FROM cst_inv_layer_cost_details CILCD
479: WHERE CILCD.inv_layer_id = (
480: SELECT MIN(inv_layer_id)
481: FROM cst_inv_layers
482: WHERE layer_id = l_layer_id
483: AND layer_quantity > 0
484: AND creation_date = (
485: SELECT MIN(creation_date)

Line 486: FROM cst_inv_layers

482: WHERE layer_id = l_layer_id
483: AND layer_quantity > 0
484: AND creation_date = (
485: SELECT MIN(creation_date)
486: FROM cst_inv_layers
487: WHERE layer_id = l_layer_id
488: AND layer_quantity > 0
489: )
490: );

Line 3124: from cst_inv_layers

3120: -- or if the cost method is FIFO or LIFO
3121:
3122: select nvl(max(inv_layer_id), 0)
3123: into l_inv_layer_id
3124: from cst_inv_layers
3125: where layer_id = l_from_layer;
3126:
3127: if l_debug = 'Y' then
3128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction: ' || to_char(i_txn_id)

Line 3299: SELECT cst_inv_layers_s.nextval

3295: */
3296:
3297: if(l_inv_layer_id = 0) then
3298: l_stmt_num := 86;
3299: SELECT cst_inv_layers_s.nextval
3300: INTO l_inv_layer_id
3301: FROM dual;
3302: l_stmt_num :=87;
3303: SELECT transaction_source_id

Line 3311: INTO cst_inv_layers (

3307: l_stmt_num :=88;
3308: l_src_number := CSTPLENG.GET_SOURCE_NUMBER(i_txn_id,i_txn_src_type,l_src_id);
3309: l_stmt_num :=89;
3310: INSERT
3311: INTO cst_inv_layers (
3312: layer_id,
3313: inv_layer_id,
3314: organization_id,
3315: inventory_item_id,