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_COPY_BILL dependencies on BOM_INVENTORY_COMPONENTS

Line 34: -- | NEW COLUMNS ADDED IN BOM_INVENTORY_COMPONENTS |

30: -- | rev_date Revision date to copy |
31: -- | |
32: -- | 01/09/2003 kIRAN kONADA |
33: -- | BUGFIX 2740820 |
34: -- | NEW COLUMNS ADDED IN BOM_INVENTORY_COMPONENTS |
35: -- | FOR CTO NEED TO COPIED DURING COPY_BILL PROCESS |
36: -- | 01/10/2003 Kiran Konada |
37: -- | bugfix 2740820 |
38: -- | cpoying another attribute plan_level |

Line 69: FROM bom_inventory_components

65: sql_stmt_num := 1;
66:
67: SELECT COUNT (*)
68: INTO total_inventory_components
69: FROM bom_inventory_components
70: WHERE bill_sequence_id = from_bill_seq_id
71: AND NVL (eco_for_production, 2) = 2
72: AND ((x_unit_assembly = 'N'
73: AND ((display_option = 1) -- ALL

Line 123: bom_inventory_components bic

119:
120: SELECT COUNT (*)
121: INTO total_reference_designators
122: FROM bom_reference_designators brd,
123: bom_inventory_components bic
124: WHERE bic.bill_sequence_id = from_bill_seq_id
125: AND NVL (bic.eco_for_production, 2) = 2
126: AND bic.component_sequence_id = brd.component_sequence_id
127: AND ((x_unit_assembly = 'N'

Line 171: bom_inventory_components bic

167:
168: SELECT COUNT (*)
169: INTO total_substitute_components
170: FROM bom_substitute_components bsc,
171: bom_inventory_components bic
172: WHERE bic.bill_sequence_id = from_bill_seq_id
173: AND NVL (bic.eco_for_production, 2) = 2
174: AND bic.component_sequence_id = bsc.component_sequence_id
175: AND ((x_unit_assembly = 'N'

Line 242: FROM bom_inventory_components bic,

238: sql_stmt_num := 1;
239:
240: SELECT COUNT (*)
241: INTO total_component_operations
242: FROM bom_inventory_components bic,
243: bom_component_operations bco
244: WHERE bic.bill_sequence_id = from_bill_seq_id
245: AND NVL (bic.eco_for_production, 2) = 2
246: AND bic.component_sequence_id = bco.component_sequence_id

Line 706: bom_inventory_components bic

702: FROM DUAL
703: WHERE EXISTS (
704: SELECT NULL
705: FROM bom_structures_b bom,
706: bom_inventory_components bic
707: WHERE bom.organization_id <> to_org_id
708: AND bom.common_bill_sequence_id = to_sequence_id
709: AND bic.bill_sequence_id = to_sequence_id
710: AND NOT EXISTS (

Line 851: FROM bom_inventory_components bic,

847: IS
848: SELECT bic.component_sequence_id,
849: bic.component_item_id,
850: bic.operation_seq_num
851: FROM bom_inventory_components bic,
852: mtl_system_items msi
853: WHERE bic.bill_sequence_id = p_from_sequence_id
854: AND bic.component_item_id = msi.inventory_item_id
855: AND bic.component_item_id <> p_to_item_id

Line 932: FROM bom_inventory_components bic

928: IS
929: /*Ideally we should be doing an effectivity check here as well
930: Left for later*/
931: SELECT component_sequence_id
932: FROM bom_inventory_components bic
933: WHERE bill_sequence_id = p_to_bill_sequence_id
934: AND component_item_id = p_copied_comp_item_id
935: AND operation_seq_num = p_copied_op_seq_num;
936:

Line 1339: descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS';

1335:
1336: --get context field name
1337: select default_context_field_name, context_column_name into l_context, l_context_column
1338: from FND_DESCRIPTIVE_FLEXS where application_id = l_app_id and
1339: descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS';
1340:
1341: --process further only when reference field is set
1342: if ((l_context_column = 'ATTRIBUTE_CATEGORY') and (l_context is not null)) then
1343: --update attribute category only when reference field has a value of $PROFILE.profile_name

Line 1566: bom_inventory_components_s.NEXTVAL,

1562: NULL,
1563: AA.primary_unit_of_measure,
1564: MSI.primary_unit_of_measure))) Comp_high_qty,
1565: x_acd_type,
1566: bom_inventory_components_s.NEXTVAL,
1567: DECODE (x_acd_type,
1568: NULL, NULL,
1569: bom_inventory_components_s.CURRVAL
1570: ),

Line 1569: bom_inventory_components_s.CURRVAL

1565: x_acd_type,
1566: bom_inventory_components_s.NEXTVAL,
1567: DECODE (x_acd_type,
1568: NULL, NULL,
1569: bom_inventory_components_s.CURRVAL
1570: ),
1571: to_sequence_id,
1572: fnd_global.conc_request_id,
1573: NULL,

Line 1963: bom_inventory_components_s.NEXTVAL,

1959: NULL,
1960: AA.primary_unit_of_measure,
1961: MSI.primary_unit_of_measure))) Comp_high_qty,
1962: x_acd_type,
1963: bom_inventory_components_s.NEXTVAL,
1964: DECODE (x_acd_type,
1965: NULL, NULL,
1966: bom_inventory_components_s.CURRVAL
1967: ),

Line 1966: bom_inventory_components_s.CURRVAL

1962: x_acd_type,
1963: bom_inventory_components_s.NEXTVAL,
1964: DECODE (x_acd_type,
1965: NULL, NULL,
1966: bom_inventory_components_s.CURRVAL
1967: ),
1968: to_sequence_id,
1969: fnd_global.conc_request_id,
1970: NULL,

Line 2364: bom_inventory_components_s.NEXTVAL,

2360: AA.primary_unit_of_measure,
2361: MSI.primary_unit_of_measure))) Comp_high_qty,
2362:
2363: x_acd_type,
2364: bom_inventory_components_s.NEXTVAL,
2365: DECODE (x_acd_type,
2366: NULL, NULL,
2367: bom_inventory_components_s.CURRVAL
2368: ),

Line 2367: bom_inventory_components_s.CURRVAL

2363: x_acd_type,
2364: bom_inventory_components_s.NEXTVAL,
2365: DECODE (x_acd_type,
2366: NULL, NULL,
2367: bom_inventory_components_s.CURRVAL
2368: ),
2369: to_sequence_id,
2370: fnd_global.conc_request_id,
2371: NULL,

Line 2839: bom_inventory_components_s.NEXTVAL,

2835: NULL,
2836: AA.primary_unit_of_measure,
2837: MSI.primary_unit_of_measure))) Comp_high_qty,
2838: x_acd_type,
2839: bom_inventory_components_s.NEXTVAL,
2840: DECODE (x_acd_type,
2841: NULL, NULL,
2842: bom_inventory_components_s.CURRVAL
2843: ),

Line 2842: bom_inventory_components_s.CURRVAL

2838: x_acd_type,
2839: bom_inventory_components_s.NEXTVAL,
2840: DECODE (x_acd_type,
2841: NULL, NULL,
2842: bom_inventory_components_s.CURRVAL
2843: ),
2844: to_sequence_id,
2845: fnd_global.conc_request_id,
2846: NULL,

Line 3282: bom_inventory_components_s.NEXTVAL,

3278: NULL,
3279: AA.primary_unit_of_measure,
3280: MSI.primary_unit_of_measure))) Comp_high_qty,
3281: x_acd_type,
3282: bom_inventory_components_s.NEXTVAL,
3283: DECODE (x_acd_type,
3284: NULL, NULL,
3285: bom_inventory_components_s.CURRVAL
3286: ),

Line 3285: bom_inventory_components_s.CURRVAL

3281: x_acd_type,
3282: bom_inventory_components_s.NEXTVAL,
3283: DECODE (x_acd_type,
3284: NULL, NULL,
3285: bom_inventory_components_s.CURRVAL
3286: ),
3287: to_sequence_id,
3288: fnd_global.conc_request_id,
3289: NULL,

Line 4771: bom_inventory_components_s.NEXTVAL,

4767: NULL,
4768: AA.primary_unit_of_measure,
4769: MSI.primary_unit_of_measure))) Comp_high_qty,
4770: x_acd_type,
4771: bom_inventory_components_s.NEXTVAL,
4772: DECODE (x_acd_type,
4773: NULL, NULL,
4774: bom_inventory_components_s.CURRVAL
4775: ),

Line 4774: bom_inventory_components_s.CURRVAL

4770: x_acd_type,
4771: bom_inventory_components_s.NEXTVAL,
4772: DECODE (x_acd_type,
4773: NULL, NULL,
4774: bom_inventory_components_s.CURRVAL
4775: ),
4776: to_sequence_id,
4777: fnd_global.conc_request_id,
4778: NULL,

Line 4875: FROM bom_inventory_components bic,

4871: bic.suggested_vendor_name,
4872: bic.vendor_id,
4873: bic.unit_price,
4874: bic.basis_type
4875: FROM bom_inventory_components bic,
4876: mtl_system_items msi,
4877: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
4878: WHERE bic.bill_sequence_id = x_from_sequence_id
4879: AND bic.component_item_id = msi.inventory_item_id

Line 5015: UPDATE bom_inventory_components

5011: IF (to_rtg_seq_id = -1)
5012: THEN
5013: sql_stmt_num := 30;
5014:
5015: UPDATE bom_inventory_components
5016: SET operation_seq_num = 1
5017: WHERE bill_sequence_id = to_sequence_id;
5018: ELSE
5019: sql_stmt_num := 35;

Line 5021: UPDATE bom_inventory_components bic

5017: WHERE bill_sequence_id = to_sequence_id;
5018: ELSE
5019: sql_stmt_num := 35;
5020:
5021: UPDATE bom_inventory_components bic
5022: SET operation_seq_num = 1
5023: WHERE bill_sequence_id = to_sequence_id
5024: AND NOT EXISTS (
5025: SELECT NULL

Line 5063: FROM bom_inventory_components bic

5059: )
5060: THEN
5061: SELECT COUNT (*)
5062: INTO dummy
5063: FROM bom_inventory_components bic
5064: WHERE bic.bill_sequence_id = to_sequence_id
5065: AND EXISTS (
5066: SELECT NULL
5067: FROM bom_inventory_components bic2

Line 5067: FROM bom_inventory_components bic2

5063: FROM bom_inventory_components bic
5064: WHERE bic.bill_sequence_id = to_sequence_id
5065: AND EXISTS (
5066: SELECT NULL
5067: FROM bom_inventory_components bic2
5068: WHERE bic2.bill_sequence_id = to_sequence_id
5069: AND bic2.ROWID <> bic.ROWID
5070: AND bic2.operation_seq_num = bic.operation_seq_num
5071: AND bic2.component_item_id = bic.component_item_id

Line 5122: FROM bom_inventory_components bic

5118: ));
5119: ELSE
5120: SELECT COUNT (*)
5121: INTO dummy
5122: FROM bom_inventory_components bic
5123: WHERE bic.bill_sequence_id = to_sequence_id
5124: AND EXISTS (
5125: SELECT NULL
5126: FROM bom_inventory_components bic2

Line 5126: FROM bom_inventory_components bic2

5122: FROM bom_inventory_components bic
5123: WHERE bic.bill_sequence_id = to_sequence_id
5124: AND EXISTS (
5125: SELECT NULL
5126: FROM bom_inventory_components bic2
5127: WHERE bic2.bill_sequence_id = to_sequence_id
5128: AND bic2.ROWID <> bic.ROWID
5129: AND bic2.operation_seq_num = bic.operation_seq_num
5130: AND bic2.component_item_id = bic.component_item_id

Line 5468: DELETE FROM bom_inventory_components bic

5464: END IF;
5465:
5466: sql_stmt_num := 41;
5467:
5468: DELETE FROM bom_inventory_components bic
5469: WHERE bic.bill_sequence_id = to_sequence_id
5470: AND EXISTS (
5471: SELECT NULL
5472: FROM mtl_system_items msi1, -- bom

Line 5708: bom_inventory_components bic

5704: brd.attribute13,
5705: brd.attribute14,
5706: brd.attribute15
5707: FROM bom_reference_designators brd,
5708: bom_inventory_components bic
5709: WHERE bic.bill_sequence_id = to_sequence_id
5710: AND NVL (bic.eco_for_production, 2) = 2
5711: AND brd.component_sequence_id = bic.created_by
5712: AND NVL (brd.acd_type, 1) <> 3;

Line 5944: bom_inventory_components bic,

5940: bsc.attribute14,
5941: bsc.attribute15,
5942: bsc.enforce_int_requirements
5943: FROM bom_substitute_components bsc,
5944: bom_inventory_components bic,
5945: mtl_system_items msi,
5946: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
5947: WHERE bic.bill_sequence_id = to_sequence_id
5948: AND NVL (bic.eco_for_production, 2) = 2

Line 6151: bom_inventory_components bic,

6147: NULL,
6148: fnd_global.conc_program_id,
6149: sysdate
6150: FROM bom_component_operations bco,
6151: bom_inventory_components bic,
6152: bom_operation_sequences bos
6153: WHERE bic.bill_sequence_id = to_sequence_id
6154: AND NVL (bic.eco_for_production, 2) = 2
6155: AND bco.component_sequence_id = bic.created_by

Line 7332: bom_inventory_components bic

7328: FROM DUAL
7329: WHERE EXISTS (
7330: SELECT NULL
7331: FROM bom_structures_b bom,
7332: bom_inventory_components bic
7333: WHERE bom.organization_id <> to_org_id
7334: AND bom.common_bill_sequence_id = to_sequence_id
7335: AND bic.bill_sequence_id = to_sequence_id
7336: AND NOT EXISTS (

Line 7705: descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS';

7701:
7702: --get context field name
7703: select default_context_field_name, context_column_name into l_context, l_context_column
7704: from FND_DESCRIPTIVE_FLEXS where application_id = l_app_id and
7705: descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS';
7706:
7707: --process further only when reference field is set
7708: if ((l_context_column = 'ATTRIBUTE_CATEGORY') and (l_context is not null)) then
7709: --update attribute category only when reference field has a value of $PROFILE.profile_name

Line 7879: bom_inventory_components_s.NEXTVAL,

7875: NULL,
7876: AA.primary_unit_of_measure,
7877: MSI.primary_unit_of_measure))) Comp_high_qty,
7878: x_acd_type,
7879: bom_inventory_components_s.NEXTVAL,
7880: DECODE (x_acd_type,
7881: NULL, NULL,
7882: bom_inventory_components_s.CURRVAL
7883: ),

Line 7882: bom_inventory_components_s.CURRVAL

7878: x_acd_type,
7879: bom_inventory_components_s.NEXTVAL,
7880: DECODE (x_acd_type,
7881: NULL, NULL,
7882: bom_inventory_components_s.CURRVAL
7883: ),
7884: to_sequence_id,
7885: fnd_global.conc_request_id,
7886: NULL,

Line 8248: bom_inventory_components_s.NEXTVAL,

8244: NULL,
8245: AA.primary_unit_of_measure,
8246: MSI.primary_unit_of_measure))) Comp_high_qty,
8247: x_acd_type,
8248: bom_inventory_components_s.NEXTVAL,
8249: DECODE (x_acd_type,
8250: NULL, NULL,
8251: bom_inventory_components_s.CURRVAL
8252: ),

Line 8251: bom_inventory_components_s.CURRVAL

8247: x_acd_type,
8248: bom_inventory_components_s.NEXTVAL,
8249: DECODE (x_acd_type,
8250: NULL, NULL,
8251: bom_inventory_components_s.CURRVAL
8252: ),
8253: to_sequence_id,
8254: fnd_global.conc_request_id,
8255: NULL,

Line 8615: bom_inventory_components_s.NEXTVAL,

8611: NULL,
8612: AA.primary_unit_of_measure,
8613: MSI.primary_unit_of_measure))) Comp_high_qty,
8614: x_acd_type,
8615: bom_inventory_components_s.NEXTVAL,
8616: DECODE (x_acd_type,
8617: NULL, NULL,
8618: bom_inventory_components_s.CURRVAL
8619: ),

Line 8618: bom_inventory_components_s.CURRVAL

8614: x_acd_type,
8615: bom_inventory_components_s.NEXTVAL,
8616: DECODE (x_acd_type,
8617: NULL, NULL,
8618: bom_inventory_components_s.CURRVAL
8619: ),
8620: to_sequence_id,
8621: fnd_global.conc_request_id,
8622: NULL,

Line 9028: bom_inventory_components_s.NEXTVAL,

9024: AA.primary_unit_of_measure,
9025: MSI.primary_unit_of_measure))) Comp_high_qty,
9026:
9027: x_acd_type,
9028: bom_inventory_components_s.NEXTVAL,
9029: DECODE (x_acd_type,
9030: NULL, NULL,
9031: bom_inventory_components_s.CURRVAL
9032: ),

Line 9031: bom_inventory_components_s.CURRVAL

9027: x_acd_type,
9028: bom_inventory_components_s.NEXTVAL,
9029: DECODE (x_acd_type,
9030: NULL, NULL,
9031: bom_inventory_components_s.CURRVAL
9032: ),
9033: to_sequence_id,
9034: fnd_global.conc_request_id,
9035: NULL,

Line 9428: bom_inventory_components_s.NEXTVAL,

9424: NULL,
9425: AA.primary_unit_of_measure,
9426: MSI.primary_unit_of_measure))) Comp_high_qty,
9427: x_acd_type,
9428: bom_inventory_components_s.NEXTVAL,
9429: DECODE (x_acd_type,
9430: NULL, NULL,
9431: bom_inventory_components_s.CURRVAL
9432: ),

Line 9431: bom_inventory_components_s.CURRVAL

9427: x_acd_type,
9428: bom_inventory_components_s.NEXTVAL,
9429: DECODE (x_acd_type,
9430: NULL, NULL,
9431: bom_inventory_components_s.CURRVAL
9432: ),
9433: to_sequence_id,
9434: fnd_global.conc_request_id,
9435: NULL,

Line 10741: UPDATE bom_inventory_components

10737: IF (to_rtg_seq_id = -1)
10738: THEN
10739: sql_stmt_num := 30;
10740:
10741: UPDATE bom_inventory_components
10742: SET operation_seq_num = 1
10743: WHERE bill_sequence_id = to_sequence_id;
10744: ELSE
10745: sql_stmt_num := 35;

Line 10747: UPDATE bom_inventory_components bic

10743: WHERE bill_sequence_id = to_sequence_id;
10744: ELSE
10745: sql_stmt_num := 35;
10746:
10747: UPDATE bom_inventory_components bic
10748: SET operation_seq_num = 1
10749: WHERE bill_sequence_id = to_sequence_id
10750: AND NOT EXISTS (
10751: SELECT NULL

Line 10789: FROM bom_inventory_components bic

10785: )
10786: THEN
10787: SELECT COUNT (*)
10788: INTO dummy
10789: FROM bom_inventory_components bic
10790: WHERE bic.bill_sequence_id = to_sequence_id
10791: AND EXISTS (
10792: SELECT NULL
10793: FROM bom_inventory_components bic2

Line 10793: FROM bom_inventory_components bic2

10789: FROM bom_inventory_components bic
10790: WHERE bic.bill_sequence_id = to_sequence_id
10791: AND EXISTS (
10792: SELECT NULL
10793: FROM bom_inventory_components bic2
10794: WHERE bic2.bill_sequence_id = to_sequence_id
10795: AND bic2.ROWID <> bic.ROWID
10796: AND bic2.operation_seq_num = bic.operation_seq_num
10797: AND bic2.component_item_id = bic.component_item_id

Line 10850: FROM bom_inventory_components bic

10846: AND bcb.revised_item_sequence_id = rev_item_seq_id;
10847: ELSE
10848: SELECT COUNT (*)
10849: INTO dummy
10850: FROM bom_inventory_components bic
10851: WHERE bic.bill_sequence_id = to_sequence_id
10852: AND EXISTS (
10853: SELECT NULL
10854: FROM bom_inventory_components bic2

Line 10854: FROM bom_inventory_components bic2

10850: FROM bom_inventory_components bic
10851: WHERE bic.bill_sequence_id = to_sequence_id
10852: AND EXISTS (
10853: SELECT NULL
10854: FROM bom_inventory_components bic2
10855: WHERE bic2.bill_sequence_id = to_sequence_id
10856: AND bic2.ROWID <> bic.ROWID
10857: AND bic2.operation_seq_num = bic.operation_seq_num
10858: AND bic2.component_item_id = bic.component_item_id

Line 11194: DELETE FROM bom_inventory_components bic

11190: AND bcb.revised_item_sequence_id = rev_item_seq_id;
11191:
11192: sql_stmt_num := 41;
11193:
11194: DELETE FROM bom_inventory_components bic
11195: WHERE bic.bill_sequence_id = to_sequence_id
11196: AND EXISTS (
11197: SELECT NULL
11198: FROM mtl_system_items msi1, -- bom

Line 11831: FROM bom_inventory_components bic,

11827: IS
11828: SELECT bic.component_item_id component_item_id
11829: , bic.change_notice change_notice
11830: , bic.implementation_date implementation_date
11831: FROM bom_inventory_components bic,
11832: bom_structures_b bsb
11833: WHERE bic.bill_sequence_id = bsb.bill_sequence_id
11834: AND bsb.bill_sequence_id = p_bill_seq_id
11835: --Bug 10331803. Should not validate currently disabled components.