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.BOM_VALIDATE_REF_DESIGNATOR dependencies on BOM_INVENTORY_COMPONENTS

Line 63: bom_inventory_components bic

59: And nvl(brd.acd_type, X_Add) = X_Add
60: Union
61: Select brd.component_reference_designator
62: From bom_reference_designators brd,
63: bom_inventory_components bic
64: Where /* Bug 9346685 : Replaced decode with conditions
65: DECODE(bic.old_component_sequence_id, NULL,
66: bic.component_sequence_id,
67: bic.old_component_sequence_id) = p_old_component_sequence_id */

Line 78: bom_inventory_components bic

74: And brd.acd_type = X_Add
75: Minus
76: Select brd.component_reference_designator
77: From bom_reference_designators brd,
78: bom_inventory_components bic
79: Where /* Bug 9346685 : Replaced decode with conditions
80: DECODE(bic.old_component_sequence_id, NULL,
81: bic.component_sequence_id,
82: bic.old_component_sequence_id) = p_old_component_sequence_id */

Line 97: bom_inventory_components bic

93: BEGIN
94: Select count(*)
95: Into X_TotalQuantity
96: From bom_reference_designators brd ,
97: bom_inventory_components bic
98: Where brd.component_sequence_id = p_old_component_sequence_id
99: And bic.component_sequence_id = brd.component_sequence_id
100: And bic.implementation_date is NOT NULL
101: And nvl(brd.acd_type, 1) = 1 ;

Line 149: FROM bom_inventory_components

145: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
146:
147: CURSOR c_QuantityRelated IS
148: SELECT component_quantity
149: FROM bom_inventory_components
150: WHERE component_sequence_id = p_component_sequence_id
151: AND quantity_related = 1;
152:
153: CURSOR c_acdtype IS

Line 155: FROM bom_inventory_components bic

151: AND quantity_related = 1;
152:
153: CURSOR c_acdtype IS
154: SELECT acd_type, old_component_sequence_id
155: FROM bom_inventory_components bic
156: WHERE bic.component_sequence_id = p_component_sequence_id;
157: BEGIN
158:
159: /*****************************************************************

Line 249: FROM bom_inventory_components bic

245: l_parent_BIT NUMBER;
246:
247: CURSOR c_acdtype IS
248: SELECT acd_type, old_component_sequence_id
249: FROM bom_inventory_components bic
250: WHERE bic.component_sequence_id =
251: p_Ref_Desg_Unexp_Rec.component_sequence_id;
252:
253: CURSOR c_QuantityRelated IS

Line 255: FROM bom_inventory_components

251: p_Ref_Desg_Unexp_Rec.component_sequence_id;
252:
253: CURSOR c_QuantityRelated IS
254: SELECT component_quantity
255: FROM bom_inventory_components
256: WHERE component_sequence_id =
257: p_Ref_Desg_Unexp_rec.component_sequence_id
258: AND quantity_related = 1;
259: BEGIN

Line 277: bom_inventory_components bic,

273: l_rec_ATO_flag,
274: l_rec_optional
275: FROM mtl_system_items msi,
276: mtl_system_items msi2,
277: bom_inventory_components bic,
278: bom_bill_of_materials bbom
279: WHERE msi.inventory_item_id = bbom.assembly_item_id
280: AND msi.organization_id = bbom.organization_id
281: AND msi2.inventory_item_id = bic.component_item_id

Line 437: bom_inventory_components bic

433:
434: SELECT component_reference_designator
435: INTO l_dummy
436: FROM bom_reference_designators brd,
437: bom_inventory_components bic
438: WHERE bic.component_sequence_id =
439: p_ref_desg_unexp_rec.component_sequence_id
440: AND brd.component_sequence_id = bic.old_component_sequence_id
441: AND brd.component_reference_designator =

Line 519: FROM bom_inventory_Components bic

515:
516: BEGIN
517: SELECT 'Non-Standard Comp'
518: INTO l_dummy
519: FROM bom_inventory_Components bic
520: WHERE bic.component_sequence_id =
521: p_Ref_Desg_Unexp_Rec.component_sequence_id
522: AND bic.bom_item_type in (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
523:

Line 568: bom_inventory_components bic

564: FROM sys.dual
565: WHERE EXISTS (SELECT 'Planning Item'
566: FROM bom_bill_of_materials bom,
567: mtl_system_items msi,
568: bom_inventory_components bic
569: WHERE msi.bom_item_type = 3 /* PLANNING */
570: AND msi.inventory_item_id = bom.assembly_item_id
571: AND msi.organization_id = bom.organization_id
572: AND bom.bill_sequence_id = bic.bill_sequence_id

Line 884: bom_inventory_components bic,

880: l_rec_ATO_flag,
881: l_rec_optional
882: FROM mtl_system_items msi,
883: mtl_system_items msi2,
884: bom_inventory_components bic,
885: bom_bill_of_materials bbom
886: WHERE msi.inventory_item_id = bbom.assembly_item_id
887: AND msi.organization_id = bbom.organization_id
888: AND msi2.inventory_item_id = bic.component_item_id

Line 944: FROM bom_inventory_components

940: ************************************************************************/
941: BEGIN
942: SELECT 'Related'
943: INTO l_dummy
944: FROM bom_inventory_components
945: WHERE quantity_related = 1
946: AND component_sequence_id =
947: p_ref_desg_Unexp_rec.component_sequence_id;
948:

Line 1093: FROM bom_inventory_components

1089: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1090:
1091: CURSOR c_GetComponent IS
1092: SELECT revised_item_sequence_id
1093: FROM bom_inventory_components
1094: WHERE component_item_id= p_ref_desg_unexp_rec.component_item_id
1095: AND operation_seq_num=p_ref_designator_rec.operation_sequence_number
1096: AND effectivity_date = p_ref_designator_rec.start_effective_date
1097: AND bill_sequence_id = p_ref_desg_unexp_rec.bill_sequence_id;

Line 1155: FROM bom_inventory_components bic

1151: ************************************************************************/
1152: BEGIN
1153: SELECT 'parent not disabled'
1154: INTO l_dummy
1155: FROM bom_inventory_components bic
1156: WHERE bic.component_sequence_id =
1157: p_Ref_Desg_Unexp_Rec.component_sequence_id
1158: AND NVL(bic.acd_type, 0) <> 3;
1159: EXCEPTION