DBA Data[Home] [Help]

APPS.INVPPRCI dependencies on CST_QUANTITY_LAYERS

Line 895: insert a blank row in cst_quantity_layers to earn MOH when the

891: (MP1.ORGANIZATION_ID = validation_org ));
892:
893:
894: /* If the config item is being created in an average costing organisation
895: insert a blank row in cst_quantity_layers to earn MOH when the
896: item is transacted. If the item is being created in the shipping org,
897: and the corrosponding Sales order has project refrence, use projects
898: cost_group_id.
899: */

Line 915: insert into cst_quantity_layers (

911: where ppp.project_id = nxtconfig.project_id
912: and ppp.organization_id = nxtconfig.organization_id;
913: end if;
914:
915: insert into cst_quantity_layers (
916: layer_id,
917: organization_id,
918: inventory_item_id,
919: cost_group_id,

Line 951: cst_quantity_layers_s.nextval,

947: BURDEN_COST,
948: CREATE_TRANSACTION_ID
949: )
950: Select
951: cst_quantity_layers_s.nextval,
952: MP1.organization_id,
953: SI.inventory_item_id,
954: DECODE(MP1.ORGANIZATION_ID, SI.ORGANIZATION_ID,l_cost_group_id,1), /* cost_group_id */
955: 0,