eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_ITEM_PK dependencies on STANDARD

Line 137: | made changes to get only standard

Line 2355: -- exploded for standard items

2351: )
2352: and bic.optional = 2 /* NOT OPTIONAL */
2353: and msi2.bom_item_type = 4 /* 2400948 */
2354: -- Model or Option Class or ATO ITEM * * BUG#2378556 commented for bug 3314297 mandatory comps should be
2355: -- exploded for standard items
2356:
2357: and msi.pick_components_flag <> 'Y' ;
2358:
2359: -- start bugfix 2425667

Line 3294: -- standard items

3290: )
3291: and bic.optional = 2 /* NOT OPTIONAL */
3292: and msi2.bom_item_type = 4 /* BUGFIX 2400948 */
3293: -- Model or Option Class or ATO ITEM * * BUG#2378556 bug 3314297 mandatory comps should be exploded for
3294: -- standard items
3295: and msi.pick_components_flag <> 'Y' ;
3296:
3297: IF PG_DEBUG <> 0 THEN
3298: oe_debug_pub.add('load_mandatory_components: ' || 'Row Count : ' || SQL%ROWCOUNT);

Line 5175: 4, -- BOM_ITEM_TYPE : standard

5171: m.planning_time_fence_days,
5172: m.demand_time_fence_days,
5173: m.end_assembly_pegging_flag,
5174: m.planning_exception_set,
5175: 4, -- BOM_ITEM_TYPE : standard
5176: 'N',
5177: 'Y',
5178: pModelId,
5179: evaluate_atp_attributes( m.atp_flag, m.atp_components_flag ),

Line 5961: -- This will make sure that item specific conversions take precedence over standard conversions.

5957: -- weight of that configuration. This then is added to the next higher level ATO to calculate the weight
5958: -- of the next higher configuration and so on until the weight of the top model ATO is calculated.
5959:
5960: -- bugfix 2301167: added inventory_item_id in the select list as well as in group by clause.
5961: -- This will make sure that item specific conversions take precedence over standard conversions.
5962: -- Also, for inter-class conversions, item-id is required.
5963: -- Also added "weight_uom_code is not null" and "unit_weight is not null" condition to filter out
5964: -- items for which these have not been defined.
5965:

Line 6805: /* For standard costing orgs, we will copy model's user-defined

6801:
6802:
6803:
6804:
6805: /* For standard costing orgs, we will copy model's user-defined
6806: cost in Frozen to the config in CTO cost type. */
6807:
6808: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
6809: begin

Line 7148: /* For standard costing orgs, we will copy model's user-defined

7144:
7145:
7146:
7147:
7148: /* For standard costing orgs, we will copy model's user-defined
7149: cost in Frozen to the config in CTO cost type. */
7150:
7151: insert into cst_item_cost_details
7152: (inventory_item_id,

Line 7325: INSERT INTO cst_standard_costs

7321: IF PG_DEBUG <> 0 THEN
7322: oe_debug_pub.add('Create_Item: ' || 'Inserting records in csc and cec',2);
7323: END IF;
7324:
7325: INSERT INTO cst_standard_costs
7326: (cost_update_id,
7327: organization_id,
7328: inventory_item_id,
7329: last_update_date,

Line 7334: standard_cost_revision_date,

7330: last_updated_by,
7331: creation_date,
7332: created_by,
7333: last_update_login,
7334: standard_cost_revision_date,
7335: standard_cost
7336: )
7337: SELECT l_cost_update,
7338: v_organization_id,

Line 7335: standard_cost

7331: creation_date,
7332: created_by,
7333: last_update_login,
7334: standard_cost_revision_date,
7335: standard_cost
7336: )
7337: SELECT l_cost_update,
7338: v_organization_id,
7339: pConfigId,

Line 7353: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);

7349: AND INVENTORY_ITEM_ID = pConfigId
7350: AND COST_TYPE_ID = 1;
7351:
7352: IF PG_DEBUG <> 0 THEN
7353: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);
7354: END IF;
7355:
7356: lStmtNumber := 235;
7357:

Line 7368: standard_cost

7364: last_updated_by,
7365: creation_date,
7366: created_by,
7367: last_update_login,
7368: standard_cost
7369: )
7370: SELECT l_cost_update,
7371: v_organization_id,
7372: pConfigId,

Line 9971: 4, -- BOM_ITEM_TYPE : standard

9967: decode( get_attribute_control( 'planning_time_fence_days' ) , 1, config.planning_time_fence_days, m.planning_time_fence_days) ,
9968: decode( get_attribute_control( 'demand_time_fence_days') , 1, config.demand_time_fence_days, m.demand_time_fence_days) ,
9969: decode( get_attribute_control( 'end_assembly_pegging_flag') ,1 , config.end_assembly_pegging_flag , m.end_assembly_pegging_flag) ,
9970: decode( get_attribute_control( 'planning_exception_set' ) , 1 , config.planning_exception_set, m.planning_exception_set) ,
9971: 4, -- BOM_ITEM_TYPE : standard
9972: 'N', -- PICK_COMPONENTS_FLAG
9973: 'Y', -- REPLENISH_TO_ORDER_FLAG
9974: p_model_id, -- Base Model ID
9975: decode( get_attribute_control( 'atp_components_flag') , 1, config.atp_components_flag, evaluate_atp_attributes( m.atp_flag, m.atp_components_flag )) ,