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 2262: -- exploded for standard items

2258: )
2259: and bic.optional = 2 /* NOT OPTIONAL */
2260: and msi2.bom_item_type = 4 /* 2400948 */
2261: -- Model or Option Class or ATO ITEM * * BUG#2378556 commented for bug 3314297 mandatory comps should be
2262: -- exploded for standard items
2263:
2264: and msi.pick_components_flag <> 'Y' ;
2265:
2266: -- start bugfix 2425667

Line 3201: -- standard items

3197: )
3198: and bic.optional = 2 /* NOT OPTIONAL */
3199: and msi2.bom_item_type = 4 /* BUGFIX 2400948 */
3200: -- Model or Option Class or ATO ITEM * * BUG#2378556 bug 3314297 mandatory comps should be exploded for
3201: -- standard items
3202: and msi.pick_components_flag <> 'Y' ;
3203:
3204: IF PG_DEBUG <> 0 THEN
3205: oe_debug_pub.add('load_mandatory_components: ' || 'Row Count : ' || SQL%ROWCOUNT);

Line 5045: 4, -- BOM_ITEM_TYPE : standard

5041: m.planning_time_fence_days,
5042: m.demand_time_fence_days,
5043: m.end_assembly_pegging_flag,
5044: m.planning_exception_set,
5045: 4, -- BOM_ITEM_TYPE : standard
5046: 'N',
5047: 'Y',
5048: pModelId,
5049: evaluate_atp_attributes( m.atp_flag, m.atp_components_flag ),

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

5798: -- weight of that configuration. This then is added to the next higher level ATO to calculate the weight
5799: -- of the next higher configuration and so on until the weight of the top model ATO is calculated.
5800:
5801: -- bugfix 2301167: added inventory_item_id in the select list as well as in group by clause.
5802: -- This will make sure that item specific conversions take precedence over standard conversions.
5803: -- Also, for inter-class conversions, item-id is required.
5804: -- Also added "weight_uom_code is not null" and "unit_weight is not null" condition to filter out
5805: -- items for which these have not been defined.
5806:

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

6616:
6617:
6618:
6619:
6620: /* For standard costing orgs, we will copy model's user-defined
6621: cost in Frozen to the config in CTO cost type. */
6622:
6623: /* begin bugfix 4057651, default CTO cost type id = 7 if it does not exist */
6624: begin

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

6959:
6960:
6961:
6962:
6963: /* For standard costing orgs, we will copy model's user-defined
6964: cost in Frozen to the config in CTO cost type. */
6965:
6966: insert into cst_item_cost_details
6967: (inventory_item_id,

Line 7140: INSERT INTO cst_standard_costs

7136: IF PG_DEBUG <> 0 THEN
7137: oe_debug_pub.add('Create_Item: ' || 'Inserting records in csc and cec',2);
7138: END IF;
7139:
7140: INSERT INTO cst_standard_costs
7141: (cost_update_id,
7142: organization_id,
7143: inventory_item_id,
7144: last_update_date,

Line 7149: standard_cost_revision_date,

7145: last_updated_by,
7146: creation_date,
7147: created_by,
7148: last_update_login,
7149: standard_cost_revision_date,
7150: standard_cost
7151: )
7152: SELECT l_cost_update,
7153: v_organization_id,

Line 7150: standard_cost

7146: creation_date,
7147: created_by,
7148: last_update_login,
7149: standard_cost_revision_date,
7150: standard_cost
7151: )
7152: SELECT l_cost_update,
7153: v_organization_id,
7154: pConfigId,

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

7164: AND INVENTORY_ITEM_ID = pConfigId
7165: AND COST_TYPE_ID = 1;
7166:
7167: IF PG_DEBUG <> 0 THEN
7168: oe_debug_pub.add('Create_Item: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);
7169: END IF;
7170:
7171: lStmtNumber := 235;
7172:

Line 7183: standard_cost

7179: last_updated_by,
7180: creation_date,
7181: created_by,
7182: last_update_login,
7183: standard_cost
7184: )
7185: SELECT l_cost_update,
7186: v_organization_id,
7187: pConfigId,

Line 9636: 4, -- BOM_ITEM_TYPE : standard

9632: decode( get_attribute_control( 'planning_time_fence_days' ) , 1, config.planning_time_fence_days, m.planning_time_fence_days) ,
9633: decode( get_attribute_control( 'demand_time_fence_days') , 1, config.demand_time_fence_days, m.demand_time_fence_days) ,
9634: decode( get_attribute_control( 'end_assembly_pegging_flag') ,1 , config.end_assembly_pegging_flag , m.end_assembly_pegging_flag) ,
9635: decode( get_attribute_control( 'planning_exception_set' ) , 1 , config.planning_exception_set, m.planning_exception_set) ,
9636: 4, -- BOM_ITEM_TYPE : standard
9637: 'N', -- PICK_COMPONENTS_FLAG
9638: 'Y', -- REPLENISH_TO_ORDER_FLAG
9639: p_model_id, -- Base Model ID
9640: decode( get_attribute_control( 'atp_components_flag') , 1, config.atp_components_flag, evaluate_atp_attributes( m.atp_flag, m.atp_components_flag )) ,