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 702: bom_inventory_components bic

698: FROM DUAL
699: WHERE EXISTS (
700: SELECT NULL
701: FROM bom_structures_b bom,
702: bom_inventory_components bic
703: WHERE bom.organization_id <> to_org_id
704: AND bom.common_bill_sequence_id = to_sequence_id
705: AND bic.bill_sequence_id = to_sequence_id
706: AND NOT EXISTS (

Line 847: FROM bom_inventory_components bic,

843: IS
844: SELECT bic.component_sequence_id,
845: bic.component_item_id,
846: bic.operation_seq_num
847: FROM bom_inventory_components bic,
848: mtl_system_items msi
849: WHERE bic.bill_sequence_id = p_from_sequence_id
850: AND bic.component_item_id = msi.inventory_item_id
851: AND bic.component_item_id <> p_to_item_id

Line 928: FROM bom_inventory_components bic

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

Line 1514: bom_inventory_components_s.NEXTVAL,

1510: NULL,
1511: AA.primary_unit_of_measure,
1512: MSI.primary_unit_of_measure))) Comp_high_qty,
1513: x_acd_type,
1514: bom_inventory_components_s.NEXTVAL,
1515: DECODE (x_acd_type,
1516: NULL, NULL,
1517: bom_inventory_components_s.CURRVAL
1518: ),

Line 1517: bom_inventory_components_s.CURRVAL

1513: x_acd_type,
1514: bom_inventory_components_s.NEXTVAL,
1515: DECODE (x_acd_type,
1516: NULL, NULL,
1517: bom_inventory_components_s.CURRVAL
1518: ),
1519: to_sequence_id,
1520: fnd_global.conc_request_id,
1521: NULL,

Line 1910: bom_inventory_components_s.NEXTVAL,

1906: NULL,
1907: AA.primary_unit_of_measure,
1908: MSI.primary_unit_of_measure))) Comp_high_qty,
1909: x_acd_type,
1910: bom_inventory_components_s.NEXTVAL,
1911: DECODE (x_acd_type,
1912: NULL, NULL,
1913: bom_inventory_components_s.CURRVAL
1914: ),

Line 1913: bom_inventory_components_s.CURRVAL

1909: x_acd_type,
1910: bom_inventory_components_s.NEXTVAL,
1911: DECODE (x_acd_type,
1912: NULL, NULL,
1913: bom_inventory_components_s.CURRVAL
1914: ),
1915: to_sequence_id,
1916: fnd_global.conc_request_id,
1917: NULL,

Line 2311: bom_inventory_components_s.NEXTVAL,

2307: AA.primary_unit_of_measure,
2308: MSI.primary_unit_of_measure))) Comp_high_qty,
2309:
2310: x_acd_type,
2311: bom_inventory_components_s.NEXTVAL,
2312: DECODE (x_acd_type,
2313: NULL, NULL,
2314: bom_inventory_components_s.CURRVAL
2315: ),

Line 2314: bom_inventory_components_s.CURRVAL

2310: x_acd_type,
2311: bom_inventory_components_s.NEXTVAL,
2312: DECODE (x_acd_type,
2313: NULL, NULL,
2314: bom_inventory_components_s.CURRVAL
2315: ),
2316: to_sequence_id,
2317: fnd_global.conc_request_id,
2318: NULL,

Line 2786: bom_inventory_components_s.NEXTVAL,

2782: NULL,
2783: AA.primary_unit_of_measure,
2784: MSI.primary_unit_of_measure))) Comp_high_qty,
2785: x_acd_type,
2786: bom_inventory_components_s.NEXTVAL,
2787: DECODE (x_acd_type,
2788: NULL, NULL,
2789: bom_inventory_components_s.CURRVAL
2790: ),

Line 2789: bom_inventory_components_s.CURRVAL

2785: x_acd_type,
2786: bom_inventory_components_s.NEXTVAL,
2787: DECODE (x_acd_type,
2788: NULL, NULL,
2789: bom_inventory_components_s.CURRVAL
2790: ),
2791: to_sequence_id,
2792: fnd_global.conc_request_id,
2793: NULL,

Line 3228: bom_inventory_components_s.NEXTVAL,

3224: NULL,
3225: AA.primary_unit_of_measure,
3226: MSI.primary_unit_of_measure))) Comp_high_qty,
3227: x_acd_type,
3228: bom_inventory_components_s.NEXTVAL,
3229: DECODE (x_acd_type,
3230: NULL, NULL,
3231: bom_inventory_components_s.CURRVAL
3232: ),

Line 3231: bom_inventory_components_s.CURRVAL

3227: x_acd_type,
3228: bom_inventory_components_s.NEXTVAL,
3229: DECODE (x_acd_type,
3230: NULL, NULL,
3231: bom_inventory_components_s.CURRVAL
3232: ),
3233: to_sequence_id,
3234: fnd_global.conc_request_id,
3235: NULL,

Line 4709: bom_inventory_components_s.NEXTVAL,

4705: NULL,
4706: AA.primary_unit_of_measure,
4707: MSI.primary_unit_of_measure))) Comp_high_qty,
4708: x_acd_type,
4709: bom_inventory_components_s.NEXTVAL,
4710: DECODE (x_acd_type,
4711: NULL, NULL,
4712: bom_inventory_components_s.CURRVAL
4713: ),

Line 4712: bom_inventory_components_s.CURRVAL

4708: x_acd_type,
4709: bom_inventory_components_s.NEXTVAL,
4710: DECODE (x_acd_type,
4711: NULL, NULL,
4712: bom_inventory_components_s.CURRVAL
4713: ),
4714: to_sequence_id,
4715: fnd_global.conc_request_id,
4716: NULL,

Line 4813: FROM bom_inventory_components bic,

4809: bic.suggested_vendor_name,
4810: bic.vendor_id,
4811: bic.unit_price,
4812: bic.basis_type
4813: FROM bom_inventory_components bic,
4814: mtl_system_items msi,
4815: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
4816: WHERE bic.bill_sequence_id = x_from_sequence_id
4817: AND bic.component_item_id = msi.inventory_item_id

Line 4953: UPDATE bom_inventory_components

4949: IF (to_rtg_seq_id = -1)
4950: THEN
4951: sql_stmt_num := 30;
4952:
4953: UPDATE bom_inventory_components
4954: SET operation_seq_num = 1
4955: WHERE bill_sequence_id = to_sequence_id;
4956: ELSE
4957: sql_stmt_num := 35;

Line 4959: UPDATE bom_inventory_components bic

4955: WHERE bill_sequence_id = to_sequence_id;
4956: ELSE
4957: sql_stmt_num := 35;
4958:
4959: UPDATE bom_inventory_components bic
4960: SET operation_seq_num = 1
4961: WHERE bill_sequence_id = to_sequence_id
4962: AND NOT EXISTS (
4963: SELECT NULL

Line 5001: FROM bom_inventory_components bic

4997: )
4998: THEN
4999: SELECT COUNT (*)
5000: INTO dummy
5001: FROM bom_inventory_components bic
5002: WHERE bic.bill_sequence_id = to_sequence_id
5003: AND EXISTS (
5004: SELECT NULL
5005: FROM bom_inventory_components bic2

Line 5005: FROM bom_inventory_components bic2

5001: FROM bom_inventory_components bic
5002: WHERE bic.bill_sequence_id = to_sequence_id
5003: AND EXISTS (
5004: SELECT NULL
5005: FROM bom_inventory_components bic2
5006: WHERE bic2.bill_sequence_id = to_sequence_id
5007: AND bic2.ROWID <> bic.ROWID
5008: AND bic2.operation_seq_num = bic.operation_seq_num
5009: AND bic2.component_item_id = bic.component_item_id

Line 5060: FROM bom_inventory_components bic

5056: ));
5057: ELSE
5058: SELECT COUNT (*)
5059: INTO dummy
5060: FROM bom_inventory_components bic
5061: WHERE bic.bill_sequence_id = to_sequence_id
5062: AND EXISTS (
5063: SELECT NULL
5064: FROM bom_inventory_components bic2

Line 5064: FROM bom_inventory_components bic2

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

Line 5401: DELETE FROM bom_inventory_components bic

5397: END IF;
5398:
5399: sql_stmt_num := 41;
5400:
5401: DELETE FROM bom_inventory_components bic
5402: WHERE bic.bill_sequence_id = to_sequence_id
5403: AND EXISTS (
5404: SELECT NULL
5405: FROM mtl_system_items msi1, -- bom

Line 5617: bom_inventory_components bic

5613: brd.attribute13,
5614: brd.attribute14,
5615: brd.attribute15
5616: FROM bom_reference_designators brd,
5617: bom_inventory_components bic
5618: WHERE bic.bill_sequence_id = to_sequence_id
5619: AND NVL (bic.eco_for_production, 2) = 2
5620: AND brd.component_sequence_id = bic.created_by
5621: AND NVL (brd.acd_type, 1) <> 3;

Line 5852: bom_inventory_components bic,

5848: bsc.attribute14,
5849: bsc.attribute15,
5850: bsc.enforce_int_requirements
5851: FROM bom_substitute_components bsc,
5852: bom_inventory_components bic,
5853: mtl_system_items msi,
5854: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
5855: WHERE bic.bill_sequence_id = to_sequence_id
5856: AND NVL (bic.eco_for_production, 2) = 2

Line 6055: bom_inventory_components bic,

6051: NULL,
6052: fnd_global.conc_program_id,
6053: sysdate
6054: FROM bom_component_operations bco,
6055: bom_inventory_components bic,
6056: bom_operation_sequences bos
6057: WHERE bic.bill_sequence_id = to_sequence_id
6058: AND NVL (bic.eco_for_production, 2) = 2
6059: AND bco.component_sequence_id = bic.created_by

Line 7232: bom_inventory_components bic

7228: FROM DUAL
7229: WHERE EXISTS (
7230: SELECT NULL
7231: FROM bom_structures_b bom,
7232: bom_inventory_components bic
7233: WHERE bom.organization_id <> to_org_id
7234: AND bom.common_bill_sequence_id = to_sequence_id
7235: AND bic.bill_sequence_id = to_sequence_id
7236: AND NOT EXISTS (

Line 7738: bom_inventory_components_s.NEXTVAL,

7734: NULL,
7735: AA.primary_unit_of_measure,
7736: MSI.primary_unit_of_measure))) Comp_high_qty,
7737: x_acd_type,
7738: bom_inventory_components_s.NEXTVAL,
7739: DECODE (x_acd_type,
7740: NULL, NULL,
7741: bom_inventory_components_s.CURRVAL
7742: ),

Line 7741: bom_inventory_components_s.CURRVAL

7737: x_acd_type,
7738: bom_inventory_components_s.NEXTVAL,
7739: DECODE (x_acd_type,
7740: NULL, NULL,
7741: bom_inventory_components_s.CURRVAL
7742: ),
7743: to_sequence_id,
7744: fnd_global.conc_request_id,
7745: NULL,

Line 8107: bom_inventory_components_s.NEXTVAL,

8103: NULL,
8104: AA.primary_unit_of_measure,
8105: MSI.primary_unit_of_measure))) Comp_high_qty,
8106: x_acd_type,
8107: bom_inventory_components_s.NEXTVAL,
8108: DECODE (x_acd_type,
8109: NULL, NULL,
8110: bom_inventory_components_s.CURRVAL
8111: ),

Line 8110: bom_inventory_components_s.CURRVAL

8106: x_acd_type,
8107: bom_inventory_components_s.NEXTVAL,
8108: DECODE (x_acd_type,
8109: NULL, NULL,
8110: bom_inventory_components_s.CURRVAL
8111: ),
8112: to_sequence_id,
8113: fnd_global.conc_request_id,
8114: NULL,

Line 8473: bom_inventory_components_s.NEXTVAL,

8469: NULL,
8470: AA.primary_unit_of_measure,
8471: MSI.primary_unit_of_measure))) Comp_high_qty,
8472: x_acd_type,
8473: bom_inventory_components_s.NEXTVAL,
8474: DECODE (x_acd_type,
8475: NULL, NULL,
8476: bom_inventory_components_s.CURRVAL
8477: ),

Line 8476: bom_inventory_components_s.CURRVAL

8472: x_acd_type,
8473: bom_inventory_components_s.NEXTVAL,
8474: DECODE (x_acd_type,
8475: NULL, NULL,
8476: bom_inventory_components_s.CURRVAL
8477: ),
8478: to_sequence_id,
8479: fnd_global.conc_request_id,
8480: NULL,

Line 8885: bom_inventory_components_s.NEXTVAL,

8881: AA.primary_unit_of_measure,
8882: MSI.primary_unit_of_measure))) Comp_high_qty,
8883:
8884: x_acd_type,
8885: bom_inventory_components_s.NEXTVAL,
8886: DECODE (x_acd_type,
8887: NULL, NULL,
8888: bom_inventory_components_s.CURRVAL
8889: ),

Line 8888: bom_inventory_components_s.CURRVAL

8884: x_acd_type,
8885: bom_inventory_components_s.NEXTVAL,
8886: DECODE (x_acd_type,
8887: NULL, NULL,
8888: bom_inventory_components_s.CURRVAL
8889: ),
8890: to_sequence_id,
8891: fnd_global.conc_request_id,
8892: NULL,

Line 9284: bom_inventory_components_s.NEXTVAL,

9280: NULL,
9281: AA.primary_unit_of_measure,
9282: MSI.primary_unit_of_measure))) Comp_high_qty,
9283: x_acd_type,
9284: bom_inventory_components_s.NEXTVAL,
9285: DECODE (x_acd_type,
9286: NULL, NULL,
9287: bom_inventory_components_s.CURRVAL
9288: ),

Line 9287: bom_inventory_components_s.CURRVAL

9283: x_acd_type,
9284: bom_inventory_components_s.NEXTVAL,
9285: DECODE (x_acd_type,
9286: NULL, NULL,
9287: bom_inventory_components_s.CURRVAL
9288: ),
9289: to_sequence_id,
9290: fnd_global.conc_request_id,
9291: NULL,

Line 10588: UPDATE bom_inventory_components

10584: IF (to_rtg_seq_id = -1)
10585: THEN
10586: sql_stmt_num := 30;
10587:
10588: UPDATE bom_inventory_components
10589: SET operation_seq_num = 1
10590: WHERE bill_sequence_id = to_sequence_id;
10591: ELSE
10592: sql_stmt_num := 35;

Line 10594: UPDATE bom_inventory_components bic

10590: WHERE bill_sequence_id = to_sequence_id;
10591: ELSE
10592: sql_stmt_num := 35;
10593:
10594: UPDATE bom_inventory_components bic
10595: SET operation_seq_num = 1
10596: WHERE bill_sequence_id = to_sequence_id
10597: AND NOT EXISTS (
10598: SELECT NULL

Line 10636: FROM bom_inventory_components bic

10632: )
10633: THEN
10634: SELECT COUNT (*)
10635: INTO dummy
10636: FROM bom_inventory_components bic
10637: WHERE bic.bill_sequence_id = to_sequence_id
10638: AND EXISTS (
10639: SELECT NULL
10640: FROM bom_inventory_components bic2

Line 10640: FROM bom_inventory_components bic2

10636: FROM bom_inventory_components bic
10637: WHERE bic.bill_sequence_id = to_sequence_id
10638: AND EXISTS (
10639: SELECT NULL
10640: FROM bom_inventory_components bic2
10641: WHERE bic2.bill_sequence_id = to_sequence_id
10642: AND bic2.ROWID <> bic.ROWID
10643: AND bic2.operation_seq_num = bic.operation_seq_num
10644: AND bic2.component_item_id = bic.component_item_id

Line 10697: FROM bom_inventory_components bic

10693: AND bcb.revised_item_sequence_id = rev_item_seq_id;
10694: ELSE
10695: SELECT COUNT (*)
10696: INTO dummy
10697: FROM bom_inventory_components bic
10698: WHERE bic.bill_sequence_id = to_sequence_id
10699: AND EXISTS (
10700: SELECT NULL
10701: FROM bom_inventory_components bic2

Line 10701: FROM bom_inventory_components bic2

10697: FROM bom_inventory_components bic
10698: WHERE bic.bill_sequence_id = to_sequence_id
10699: AND EXISTS (
10700: SELECT NULL
10701: FROM bom_inventory_components bic2
10702: WHERE bic2.bill_sequence_id = to_sequence_id
10703: AND bic2.ROWID <> bic.ROWID
10704: AND bic2.operation_seq_num = bic.operation_seq_num
10705: AND bic2.component_item_id = bic.component_item_id

Line 11041: DELETE FROM bom_inventory_components bic

11037: AND bcb.revised_item_sequence_id = rev_item_seq_id;
11038:
11039: sql_stmt_num := 41;
11040:
11041: DELETE FROM bom_inventory_components bic
11042: WHERE bic.bill_sequence_id = to_sequence_id
11043: AND EXISTS (
11044: SELECT NULL
11045: FROM mtl_system_items msi1, -- bom