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 503: -- Configured items are ATO standard items that have a base item id.

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

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

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

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

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

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

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

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

Line 545: ri.bom_item_type = standard_type AND

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

Line 553: ci.bom_item_type = standard_type AND

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

Line 555: ri.bom_item_type = standard_type)

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

Line 587: -- - Revised Item is Standard or

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

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

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

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

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

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

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

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

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

Line 1145: p_standard_item_access IN NUMBER,

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

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

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

Line 1223: no, standard_type))

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

Line 2230: profile.standard_item_access,

2226:
2227: Restrict_List(list_id,
2228: profile.model_item_access,
2229: profile.planning_item_access,
2230: profile.standard_item_access,
2231: change_order,
2232: org_id,
2233: list_error_msg);
2234:

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

3691:
3692: --
3693: -- Y = Allowed N = Not Allowed
3694: -- P = Must be Phantom O = Must be Optional
3695: -- Configured items are ATO standard items that have a base item id.
3696: -- ATO items have Replenish to Order flags set to "Y".
3697: -- PTO items have Pick Component flags set to "Y".
3698: --
3699: -- Parent

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

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

3705: -- ATO Opt Class | P P P N N N N
3706: -- ATO Standard | Y Y Y Y O O N
3707: -- PTO Model | N N N N P P N
3708: -- PTO Opt Class | N N N N P P N
3709: -- PTO Standard | N N N N Y Y Y
3710: --
3711: -- NOTE: "Not Allowed" is handled by a delete statement in procedure
3712: -- Check_Combination above.
3713: --

Line 3741: AND ci.bom_item_type = standard_type

3737: bom_inventory_components c,
3738: eng_revised_items r
3739: WHERE ci.base_item_id IS NULL
3740: AND ci.replenish_to_order_flag = 'Y'
3741: AND ci.bom_item_type = standard_type
3742: AND i.pick_components_flag = 'Y'
3743: AND i.bom_item_type IN (model_type, option_class_type)
3744: AND ci.inventory_item_id = c.component_item_id
3745: AND ci.organization_id = r.organization_id