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.BOMPKMUD dependencies on STANDARD

Line 48: standard_type CONSTANT NUMBER(1) := 4;

44: --
45: model_type CONSTANT NUMBER(1) := 1;
46: option_class_type CONSTANT NUMBER(1) := 2;
47: planning_type CONSTANT NUMBER(1) := 3;
48: standard_type CONSTANT NUMBER(1) := 4;
49:
50: --
51: -- Lookup values for wip_supply_type in mtl_system_items.
52: --

Line 103: l_child_record QA_EDR_STANDARD.ERECORD_ID_TBL_TYPE;

99: WHERE change_mgmt_type_code = 'CHANGE_ORDER'
100: AND organization_id = org_id
101: AND change_notice = eco;
102:
103: l_child_record QA_EDR_STANDARD.ERECORD_ID_TBL_TYPE;
104: l_event QA_EDR_STANDARD.ERES_EVENT_REC_TYPE;
105: -- l_payload FND_WF_EVENT.PARAM_TABLE;
106: l_change_id NUMBER;
107: l_parent_record_id NUMBER;

Line 104: l_event QA_EDR_STANDARD.ERES_EVENT_REC_TYPE;

100: AND organization_id = org_id
101: AND change_notice = eco;
102:
103: l_child_record QA_EDR_STANDARD.ERECORD_ID_TBL_TYPE;
104: l_event QA_EDR_STANDARD.ERES_EVENT_REC_TYPE;
105: -- l_payload FND_WF_EVENT.PARAM_TABLE;
106: l_change_id NUMBER;
107: l_parent_record_id NUMBER;
108: l_msg_data VARCHAR2(2000);

Line 127: QA_EDR_STANDARD.GET_ERECORD_ID

123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning the ERES part for org_id='||p_organization_id||', change_notice='||p_change_notice);
124:
125: -- Get Parent Event record id :
126: -- The error is not trapped, so that the execution can carry on.
127: QA_EDR_STANDARD.GET_ERECORD_ID
128: ( p_api_version => 1.0
129: , p_init_msg_list => FND_API.G_TRUE
130: , x_return_status => x_return_status
131: , x_msg_count => x_msg_count

Line 189: QA_EDR_STANDARD.RAISE_ERES_EVENT

185: -- l_event.payload := l_payload;
186: l_event.erecord_id := l_erecord_id;
187: l_event.event_status := l_event_status;
188:
189: QA_EDR_STANDARD.RAISE_ERES_EVENT
190: ( p_api_version => 1.0
191: , p_init_msg_list => FND_API.G_FALSE
192: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
193: , x_return_status => x_return_status

Line 226: QA_EDR_STANDARD.SEND_ACKN

222: THEN
223: FND_MESSAGE.SET_NAME('ENG', 'ENG_ERES_ACKN_MASS_CHANGES');
224: l_ackn_by := FND_MESSAGE.GET;
225:
226: QA_EDR_STANDARD.SEND_ACKN
227: ( p_api_version => 1.0
228: , p_init_msg_list => FND_API.G_FALSE
229: , x_return_status => x_return_status
230: , x_msg_count => x_msg_count

Line 240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||x_msg_count);

236: , p_ackn_by => l_ackn_by
237: , p_ackn_note => '(organization_id, change_notice)='||TO_CHAR(p_organization_id)||', '||p_change_notice||')'
238: , p_autonomous_commit => FND_API.G_FALSE);
239:
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||x_msg_count);
241: IF (NVL(x_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
242: AND (x_msg_count > 0)
243: THEN
244: RAISE SEND_ACKN_ERROR;

Line 504: -- Configured items are ATO standard items that have a base item id.

500:
501: --
502: -- 1. Y = Allowed N = Not Allowed
503: -- P = Must be Phantom O = Must be Optional
504: -- Configured items are ATO standard items that have a base item id.
505: -- ATO items have Replenish to Order flags set to "Y".
506: -- PTO items have Pick Component flags set to "Y".
507: --
508: -- Parent

Line 515: -- ATO Standard | Y Y Y Y O O N

Line 518: -- PTO Standard | N N N N Y Y Y

514: -- ATO Opt Class | P P P N N N N
515: -- ATO Standard | Y Y Y Y O O N
516: -- PTO Model | N N N N P P N
517: -- PTO Opt Class | N N N N P P N
518: -- PTO Standard | N N N N Y Y Y
519: --
520: -- NOTE: Phantoms and Optional are handled by an update statement in
521: -- procedure Mass_Update below.
522: --

Line 525: -- - Revised Item is ATO Model, ATO Option Class, ATO Standard,

521: -- procedure Mass_Update below.
522: --
523: -- 2. Check Component ATP, delete bill from list if:
524: --
525: -- - Revised Item is ATO Model, ATO Option Class, ATO Standard,
526: -- PTO Model, PTO Option Class, PTO Standard or Phantom and ATP
527: -- Components Flag is set to No.
528: --
529: -- - Component Item's ATP Flag or ATP Components Flag is set to Yes.

Line 526: -- PTO Model, PTO Option Class, PTO Standard or Phantom and ATP

522: --
523: -- 2. Check Component ATP, delete bill from list if:
524: --
525: -- - Revised Item is ATO Model, ATO Option Class, ATO Standard,
526: -- PTO Model, PTO Option Class, PTO Standard or Phantom and ATP
527: -- Components Flag is set to No.
528: --
529: -- - Component Item's ATP Flag or ATP Components Flag is set to Yes.
530: --

Line 546: ri.bom_item_type = standard_type AND

542: WHERE ((ci.bom_item_type = planning_type AND
543: ri.bom_item_type <> planning_type)
544: OR
545: (ci.bom_item_type IN (model_type, option_class_type) AND
546: ri.bom_item_type = standard_type AND
547: ri.base_item_id IS NULL)
548: OR
549: (ci.replenish_to_order_flag = 'Y' AND
550: ci.bom_item_type = option_class_type AND

Line 554: ci.bom_item_type = standard_type AND

550: ci.bom_item_type = option_class_type AND
551: ri.pick_components_flag = 'Y')
552: OR
553: (ci.replenish_to_order_flag = 'Y' AND
554: ci.bom_item_type = standard_type AND
555: ri.pick_components_flag = 'Y' AND
556: ri.bom_item_type = standard_type)
557: OR
558: (ci.pick_components_flag = 'Y' AND

Line 556: ri.bom_item_type = standard_type)

552: OR
553: (ci.replenish_to_order_flag = 'Y' AND
554: ci.bom_item_type = standard_type AND
555: ri.pick_components_flag = 'Y' AND
556: ri.bom_item_type = standard_type)
557: OR
558: (ci.pick_components_flag = 'Y' AND
559: ri.replenish_to_order_flag = 'Y')
560: /* commented for bug 3548357 and 3508992

Line 588: -- - Revised Item is Standard or

584: -- Do not create revised items if:
585: --
586: -- - Optional = Yes and Revised Item <> Model/OC
587: -- - Planning Percent <> 100% and
588: -- - Revised Item is Standard or
589: -- - Revised Items is Model/OC and
590: -- Component is mandatory and is not "Consume or Derive"
591: -- - Shippable = Yes and Revised Items is not pick-to-order
592: --

Line 611: OR (i.bom_item_type = standard_type)))

607: (model_type, option_class_type)
608: AND c.optional = no
609: AND ci.ato_forecast_control <>
610: g_consume_and_derive)
611: OR (i.bom_item_type = standard_type)))
612: )
613: AND i.inventory_item_id = l.assembly_item_id
614: AND i.organization_id = r.organization_id
615: AND ci.inventory_item_id = c.component_item_id

Line 650: OR (ri_itm.bom_item_type = standard_type)))

646: AND ((ri_itm.bom_item_type IN
647: (model_type, option_class_type)
648: AND NVL(n.optional, c.optional) = no
649: AND ci_itm.ato_forecast_control <> g_consume_and_derive)
650: OR (ri_itm.bom_item_type = standard_type)))
651: )
652: AND (c.item_num = o.item_num OR o.item_num IS NULL)
653: AND (c.component_quantity = o.component_quantity
654: OR o.component_quantity IS NULL)

Line 1121: -- profile options: planning item access, standard item access

1117: -- NAME
1118: -- Restrict_List
1119: -- DESCRIPTION
1120: -- Deletes from BOM_LISTS according to access permissions granted by the
1121: -- profile options: planning item access, standard item access
1122: -- and model item access. Also culls out bills that would not
1123: -- qualify for a change order because it does not have
1124: -- components which match all the criteria specified in
1125: -- BOM_INVENTORY_COMPS_INTERFACE.

Line 1129: -- Standard Item Access - Yes (1) or No (2).

1125: -- BOM_INVENTORY_COMPS_INTERFACE.
1126: -- REQUIRES
1127: -- Model Item Access - Yes (1) or No (2).
1128: -- Planning Item Access - Yes (1) or No (2).
1129: -- Standard Item Access - Yes (1) or No (2).
1130: -- List id - A sequence id used to identify the list in BOM_LISTS. This
1131: -- may either be a session id or a number obtained from the
1132: -- database sequence, BOM_LISTS_S.
1133: -- Organization Id - Organization stored in ENG_CHANGES_INTERFACE.

Line 1146: p_standard_item_access IN NUMBER,

1142: PROCEDURE Restrict_List(
1143: p_list_id IN NUMBER,
1144: p_model_item_access IN NUMBER,
1145: p_planning_item_access IN NUMBER,
1146: p_standard_item_access IN NUMBER,
1147: p_change_order IN VARCHAR2,
1148: p_organization IN NUMBER,
1149: x_error_message IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1150: IS

Line 1223: (i.bom_item_type = DECODE(p_standard_item_access,

1219: OR
1220: (i.bom_item_type = DECODE(p_planning_item_access,
1221: no, planning_type))
1222: OR
1223: (i.bom_item_type = DECODE(p_standard_item_access,
1224: no, standard_type))
1225: )
1226: );
1227:

Line 1224: no, standard_type))

1220: (i.bom_item_type = DECODE(p_planning_item_access,
1221: no, planning_type))
1222: OR
1223: (i.bom_item_type = DECODE(p_standard_item_access,
1224: no, standard_type))
1225: )
1226: );
1227:
1228: --

Line 2236: profile.standard_item_access,

2232:
2233: Restrict_List(list_id,
2234: profile.model_item_access,
2235: profile.planning_item_access,
2236: profile.standard_item_access,
2237: change_order,
2238: org_id,
2239: list_error_msg);
2240:

Line 3701: -- Configured items are ATO standard items that have a base item id.

3697:
3698: --
3699: -- Y = Allowed N = Not Allowed
3700: -- P = Must be Phantom O = Must be Optional
3701: -- Configured items are ATO standard items that have a base item id.
3702: -- ATO items have Replenish to Order flags set to "Y".
3703: -- PTO items have Pick Component flags set to "Y".
3704: --
3705: -- Parent

Line 3712: -- ATO Standard | Y Y Y Y O O N

Line 3715: -- PTO Standard | N N N N Y Y Y

3711: -- ATO Opt Class | P P P N N N N
3712: -- ATO Standard | Y Y Y Y O O N
3713: -- PTO Model | N N N N P P N
3714: -- PTO Opt Class | N N N N P P N
3715: -- PTO Standard | N N N N Y Y Y
3716: --
3717: -- NOTE: "Not Allowed" is handled by a delete statement in procedure
3718: -- Check_Combination above.
3719: --

Line 3747: AND ci.bom_item_type = standard_type

3743: bom_inventory_components c,
3744: eng_revised_items r
3745: WHERE ci.base_item_id IS NULL
3746: AND ci.replenish_to_order_flag = 'Y'
3747: AND ci.bom_item_type = standard_type
3748: AND i.pick_components_flag = 'Y'
3749: AND i.bom_item_type IN (model_type, option_class_type)
3750: AND ci.inventory_item_id = c.component_item_id
3751: AND ci.organization_id = r.organization_id