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_COMPONENTS_B

Line 944: FROM bom_components_b bcb1,

940: )
941: IS
942: SELECT bcb1.component_sequence_id from_component_seq_id,
943: bcb2.component_sequence_id to_sequence_id
944: FROM bom_components_b bcb1,
945: bom_components_b bcb2
946: WHERE bcb1.bill_sequence_id = p_from_seq_id
947: AND bcb1.component_sequence_id = bcb2.created_by
948: AND bcb2.bill_sequence_id = p_to_seq_id;

Line 945: bom_components_b bcb2

941: IS
942: SELECT bcb1.component_sequence_id from_component_seq_id,
943: bcb2.component_sequence_id to_sequence_id
944: FROM bom_components_b bcb1,
945: bom_components_b bcb2
946: WHERE bcb1.bill_sequence_id = p_from_seq_id
947: AND bcb1.component_sequence_id = bcb2.created_by
948: AND bcb2.bill_sequence_id = p_to_seq_id;
949: l_index NUMBER := 0;

Line 960: bom_components_b bcb

956: IS
957: SELECT eec.change_id,
958: bcb.component_sequence_id
959: FROM eng_engineering_changes eec,
960: bom_components_b bcb
961: WHERE eec.change_notice = p_change_notice
962: AND eec.organization_id = p_local_org_id
963: AND bcb.bill_sequence_id = p_bill_seq_id;
964: CURSOR l_fixed_rev_comp_csr (

Line 1448: INSERT INTO bom_components_b

1444:
1445: IF l_from_eff_ctrl = 1 AND l_to_eff_ctrl = 1 THEN -- Date - Date
1446:
1447:
1448: INSERT INTO bom_components_b
1449: (shipping_allowed,
1450: required_to_ship,
1451: required_for_revenue,
1452: include_on_ship_docs,

Line 1733: FROM bom_components_b bic,

1729: THEN 0
1730: ELSE
1731: to_number(NULL)
1732: END AS to_minor_revision_id
1733: FROM bom_components_b bic,
1734: mtl_system_items msi,
1735: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
1736: bom_copy_explosions_v bev
1737: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 1765: FROM bom_components_b bcb

1761: )
1762: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
1763: (
1764: SELECT 1
1765: FROM bom_components_b bcb
1766: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
1767: AND bcb.change_notice = context_eco
1768: AND bcb.acd_type = 3
1769: AND bcb.effectivity_date <= trgt_comps_eff_date

Line 1845: INSERT INTO bom_components_b

1841: OR ( l_from_eff_ctrl = 3 AND l_to_eff_ctrl = 3 ) -- Serial
1842: ) THEN
1843:
1844:
1845: INSERT INTO bom_components_b
1846: (shipping_allowed,
1847: required_to_ship,
1848: required_for_revenue,
1849: include_on_ship_docs,

Line 2133: FROM bom_components_b bic,

2129: THEN 0
2130: ELSE
2131: to_number(NULL)
2132: END AS to_minor_revision_id
2133: FROM bom_components_b bic,
2134: mtl_system_items msi,
2135: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2136: bom_copy_explosions_v bev
2137: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 2165: FROM bom_components_b bcb

2161: )
2162: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
2163: (
2164: SELECT 1
2165: FROM bom_components_b bcb
2166: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
2167: AND bcb.change_notice = context_eco
2168: AND bcb.acd_type = 3
2169: AND bcb.effectivity_date <= trgt_comps_eff_date

Line 2245: INSERT INTO bom_components_b

2241:
2242: ELSIF l_from_eff_ctrl = 4 AND l_to_eff_ctrl = 4 THEN -- Rev - Rev
2243:
2244:
2245: INSERT INTO bom_components_b
2246: (shipping_allowed,
2247: required_to_ship,
2248: required_for_revenue,
2249: include_on_ship_docs,

Line 2610: FROM bom_components_b bic,

2606: THEN 0
2607: ELSE
2608: to_number(NULL)
2609: END AS to_minor_revision_id
2610: FROM bom_components_b bic,
2611: mtl_system_items msi,
2612: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2613: bom_copy_explosions_v bev
2614: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 2642: FROM bom_components_b bcb

2638: )
2639: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
2640: (
2641: SELECT 1
2642: FROM bom_components_b bcb
2643: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
2644: AND bcb.change_notice = context_eco
2645: AND bcb.acd_type = 3
2646: AND bcb.effectivity_date <= trgt_comps_eff_date

Line 2721: INSERT INTO bom_components_b

2717: ELSIF l_from_eff_ctrl = 4 AND l_to_eff_ctrl = 1 THEN -- Rev - Date
2718:
2719:
2720:
2721: INSERT INTO bom_components_b
2722: (shipping_allowed,
2723: required_to_ship,
2724: required_for_revenue,
2725: include_on_ship_docs,

Line 3052: FROM bom_components_b bic,

3048: THEN 0
3049: ELSE
3050: to_number(NULL)
3051: END AS to_minor_revision_id
3052: FROM bom_components_b bic,
3053: mtl_system_items msi,
3054: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3055: bom_copy_explosions_v bev
3056: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 3084: FROM bom_components_b bcb

3080: )
3081: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
3082: (
3083: SELECT 1
3084: FROM bom_components_b bcb
3085: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
3086: AND bcb.change_notice = context_eco
3087: AND bcb.acd_type = 3
3088: AND bcb.effectivity_date <= trgt_comps_eff_date

Line 3162: INSERT INTO bom_components_b

3158: );
3159: ELSIF l_from_eff_ctrl = 1 AND l_to_eff_ctrl = 4 THEN -- Date - Rev
3160:
3161:
3162: INSERT INTO bom_components_b
3163: (shipping_allowed,
3164: required_to_ship,
3165: required_for_revenue,
3166: include_on_ship_docs,

Line 3502: FROM bom_components_b bic,

3498: THEN 0
3499: ELSE
3500: to_number(NULL)
3501: END AS to_minor_revision_id
3502: FROM bom_components_b bic,
3503: mtl_system_items msi,
3504: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3505: bom_copy_explosions_v bev
3506: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 3535: FROM bom_components_b bcb

3531: )
3532: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
3533: (
3534: SELECT 1
3535: FROM bom_components_b bcb
3536: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
3537: AND bcb.change_notice = context_eco
3538: AND bcb.acd_type = 3
3539: AND bcb.effectivity_date <= trgt_comps_eff_date

Line 3782: FROM bom_components_b bcb

3778: fnd_global.conc_request_id,
3779: NULL,
3780: fnd_global.conc_program_id,
3781: sysdate
3782: FROM bom_components_b bcb
3783: WHERE bcb.component_sequence_id = l_from_comps(l_index);
3784: l_msg_count := l_error_msg_tbl.next(l_msg_count);
3785: END LOOP;
3786: END IF;

Line 3816: FROM bom_components_b bcb,

3812: END IF;
3813:
3814: SELECT COUNT (*)
3815: INTO l_no_access_comp_cnt
3816: FROM bom_components_b bcb,
3817: mtl_system_items_b_kfv msbk1,
3818: bom_copy_explosions_v bev
3819: WHERE bcb.bill_sequence_id = x_from_sequence_id
3820: AND bcb.component_item_id = msbk1.inventory_item_id

Line 3842: FROM bom_components_b bcb1

3838: )
3839: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
3840: (
3841: SELECT 1
3842: FROM bom_components_b bcb1
3843: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
3844: AND bcb1.change_notice = context_eco
3845: AND bcb1.acd_type = 3
3846: AND bcb1.effectivity_date <= trgt_comps_eff_date

Line 3913: FROM bom_components_b bcb,

3909: IF (from_org_id <> to_org_id)
3910: THEN
3911: SELECT COUNT (*)
3912: INTO l_no_access_comp_cnt
3913: FROM bom_components_b bcb,
3914: mtl_system_items_b_kfv msbk1,
3915: bom_copy_explosions_v bev
3916: WHERE bcb.bill_sequence_id = x_from_sequence_id
3917: AND bcb.component_item_id = msbk1.inventory_item_id

Line 3939: FROM bom_components_b bcb1

3935: )
3936: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
3937: (
3938: SELECT 1
3939: FROM bom_components_b bcb1
3940: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
3941: AND bcb1.change_notice = context_eco
3942: AND bcb1.acd_type = 3
3943: AND bcb1.effectivity_date <= trgt_comps_eff_date

Line 4048: FROM bom_components_b bcb,

4044: fnd_global.conc_request_id,
4045: NULL,
4046: fnd_global.conc_program_id,
4047: sysdate
4048: FROM bom_components_b bcb,
4049: mtl_system_items_b msib, -- component
4050: bom_copy_explosions_v bev
4051: WHERE bcb.bill_sequence_id = x_from_sequence_id
4052: AND bcb.component_item_id = msib.inventory_item_id

Line 4069: FROM bom_components_b bcb1

4065: )
4066: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
4067: (
4068: SELECT 1
4069: FROM bom_components_b bcb1
4070: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
4071: AND bcb1.change_notice = context_eco
4072: AND bcb1.acd_type = 3
4073: AND bcb1.effectivity_date <= trgt_comps_eff_date

Line 4137: FROM bom_components_b bcb,

4133: fnd_global.conc_request_id,
4134: NULL,
4135: fnd_global.conc_program_id,
4136: sysdate
4137: FROM bom_components_b bcb,
4138: bom_copy_explosions_v bev
4139: WHERE bcb.bill_sequence_id = x_from_sequence_id
4140: AND bcb.component_item_id <> to_item_id
4141: AND bcb.eco_for_production <> 2

Line 4154: FROM bom_components_b bcb1

4150: )
4151: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
4152: (
4153: SELECT 1
4154: FROM bom_components_b bcb1
4155: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
4156: AND bcb1.change_notice = context_eco
4157: AND bcb1.acd_type = 3
4158: AND bcb1.effectivity_date <= trgt_comps_eff_date

Line 4219: FROM bom_components_b bcb,

4215: user_id,
4216: SYSDATE,
4217: user_id,
4218: 'E'
4219: FROM bom_components_b bcb,
4220: mtl_system_items_b_kfv msbk1,
4221: mtl_system_items_b_kfv msbk2,
4222: bom_copy_explosions_v bev
4223: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 4276: FROM bom_components_b bcb,

4272: fnd_global.conc_request_id,
4273: NULL,
4274: fnd_global.conc_program_id,
4275: sysdate
4276: FROM bom_components_b bcb,
4277: mtl_system_items_b msib,
4278: bom_copy_explosions_v bev
4279: WHERE bcb.bill_sequence_id = x_from_sequence_id
4280: AND bcb.component_item_id = msib.inventory_item_id

Line 4300: FROM bom_components_b bcb1

4296: )
4297: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
4298: (
4299: SELECT 1
4300: FROM bom_components_b bcb1
4301: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
4302: AND bcb1.change_notice = context_eco
4303: AND bcb1.acd_type = 3
4304: AND bcb1.effectivity_date <= trgt_comps_eff_date

Line 4363: FROM bom_components_b bcb,

4359: fnd_global.conc_request_id,
4360: NULL,
4361: fnd_global.conc_program_id,
4362: sysdate
4363: FROM bom_components_b bcb,
4364: bom_copy_explosions_v bev
4365: WHERE bcb.bill_sequence_id = x_from_sequence_id
4366: AND bcb.component_item_id <> to_item_id
4367: AND bcb.implementation_date IS NOT NULL

Line 4380: FROM bom_components_b bcb1

4376: )
4377: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
4378: (
4379: SELECT 1
4380: FROM bom_components_b bcb1
4381: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
4382: AND bcb1.change_notice = context_eco
4383: AND bcb1.acd_type = 3
4384: AND bcb1.effectivity_date <= trgt_comps_eff_date

Line 4459: FROM bom_components_b bcb,

4455: fnd_global.conc_request_id,
4456: NULL,
4457: fnd_global.conc_program_id,
4458: sysdate
4459: FROM bom_components_b bcb,
4460: mtl_system_items_b msib
4461: WHERE bcb.bill_sequence_id = to_sequence_id
4462: AND bcb.component_item_id = msib.inventory_item_id
4463: AND msib.organization_id = to_org_id

Line 4524: FROM bom_components_b bcb,

4520: fnd_global.conc_request_id,
4521: NULL,
4522: fnd_global.conc_program_id,
4523: sysdate
4524: FROM bom_components_b bcb,
4525: mtl_system_items_b msib
4526: WHERE bcb.bill_sequence_id = to_sequence_id
4527: AND bcb.component_item_id = msib.inventory_item_id
4528: AND msib.organization_id = to_org_id

Line 4598: FROM bom_components_b bcb,

4594: fnd_global.conc_request_id,
4595: NULL,
4596: fnd_global.conc_program_id,
4597: sysdate
4598: FROM bom_components_b bcb,
4599: bom_copy_explosions_v bev
4600: WHERE bcb.bill_sequence_id = x_from_sequence_id
4601: AND bcb.component_item_id <> to_item_id
4602: AND bcb.implementation_date IS NOT NULL

Line 4617: FROM bom_components_b bcb1

4613: )
4614: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
4615: (
4616: SELECT 1
4617: FROM bom_components_b bcb1
4618: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
4619: AND bcb1.change_notice = context_eco
4620: AND bcb1.acd_type = 3
4621: AND bcb1.effectivity_date <= trgt_comps_eff_date

Line 4661: INSERT INTO bom_components_b

4657: )
4658: THEN
4659:
4660:
4661: INSERT INTO bom_components_b
4662: (shipping_allowed,
4663: required_to_ship,
4664: required_for_revenue,
4665: include_on_ship_docs,

Line 4958: UPDATE BOM_COMPONENTS_B

4954: l_count2 := replacement_items_arr.FIRST;
4955: l_count3 := replacement_items_rev_ids_arr.FIRST;
4956: IF (l_count1 IS NOT NULL AND l_count2 IS NOT NULL) THEN
4957: FORALL j IN replace_comps_arr.FIRST..replace_comps_arr.LAST
4958: UPDATE BOM_COMPONENTS_B
4959: SET COMPONENT_ITEM_ID = replacement_items_arr(j),
4960: COMPONENT_ITEM_REVISION_ID = replacement_items_rev_ids_arr(j)
4961: WHERE BILL_SEQUENCE_ID = to_sequence_id
4962: AND CREATED_BY = replace_comps_arr(j);

Line 5087: FROM bom_components_b bcb

5083: ELSIF l_to_eff_ctrl = 4
5084: THEN
5085: SELECT COUNT (*)
5086: INTO dummy
5087: FROM bom_components_b bcb
5088: WHERE bcb.bill_sequence_id = to_sequence_id
5089: AND EXISTS (
5090: SELECT NULL
5091: FROM bom_components_b bcb2

Line 5091: FROM bom_components_b bcb2

5087: FROM bom_components_b bcb
5088: WHERE bcb.bill_sequence_id = to_sequence_id
5089: AND EXISTS (
5090: SELECT NULL
5091: FROM bom_components_b bcb2
5092: WHERE bcb2.bill_sequence_id = to_sequence_id
5093: AND bcb2.ROWID <> bcb.ROWID
5094: AND bcb2.operation_seq_num = bcb.operation_seq_num
5095: AND bcb2.component_item_id = bcb.component_item_id

Line 5232: FROM bom_components_b bcb,

5228: fnd_global.conc_request_id,
5229: NULL,
5230: fnd_global.conc_program_id,
5231: sysdate
5232: FROM bom_components_b bcb,
5233: mtl_system_items_b msib1,
5234: mtl_system_items_b msib2
5235: WHERE bcb.bill_sequence_id = to_sequence_id
5236: AND (msib1.bom_item_type = planning

Line 5285: FROM bom_components_b bcb,

5281: fnd_global.conc_request_id,
5282: NULL,
5283: fnd_global.conc_program_id,
5284: sysdate
5285: FROM bom_components_b bcb,
5286: mtl_system_items_b msib1,
5287: mtl_system_items_b msib2
5288: WHERE bcb.bill_sequence_id = to_sequence_id
5289: AND (msib1.bom_item_type IN (model, option_class)

Line 5342: FROM bom_components_b bcb,

5338: fnd_global.conc_request_id,
5339: NULL,
5340: fnd_global.conc_program_id,
5341: sysdate
5342: FROM bom_components_b bcb,
5343: mtl_system_items_b msib1, -- Comp
5344: mtl_system_items_b msib2 -- Structure
5345: WHERE bcb.bill_sequence_id = to_sequence_id
5346: AND (msib1.replenish_to_order_flag = 'Y'

Line 5396: FROM bom_components_b bcb,

5392: fnd_global.conc_request_id,
5393: NULL,
5394: fnd_global.conc_program_id,
5395: sysdate
5396: FROM bom_components_b bcb,
5397: mtl_system_items_b msib1, -- Comp
5398: mtl_system_items_b msib2 -- Structure
5399: WHERE bcb.bill_sequence_id = to_sequence_id
5400: AND (msib1.replenish_to_order_flag = 'Y'

Line 5453: FROM bom_components_b bcb,

5449: fnd_global.conc_request_id,
5450: NULL,
5451: fnd_global.conc_program_id,
5452: sysdate
5453: FROM bom_components_b bcb,
5454: mtl_system_items_b msib1, -- Comp
5455: mtl_system_items_b msib2 -- Structure
5456: WHERE bcb.bill_sequence_id = to_sequence_id
5457: AND (msib1.pick_components_flag = 'Y'

Line 5508: UPDATE bom_components_b bic

5504: sql_stmt_num := 43;
5505: --Turn off trigger BOMTBICX
5506: bom_globals.g_skip_bomtbicx := 'Y';
5507:
5508: UPDATE bom_components_b bic
5509: SET bic.wip_supply_type = phantom
5510: WHERE bic.bill_sequence_id = to_sequence_id
5511: AND EXISTS (
5512: SELECT NULL

Line 5525: UPDATE bom_components_b bic

5521: bom_globals.g_skip_bomtbicx := 'N';
5522: sql_stmt_num := 44;
5523: bom_globals.g_skip_bomtbicx := 'Y';
5524:
5525: UPDATE bom_components_b bic
5526: SET bic.optional = 1
5527: WHERE bic.bill_sequence_id = to_sequence_id
5528: AND nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 --added for BOM ER 9904085
5529: AND EXISTS (

Line 5544: UPDATE bom_components_b bic

5540: AND msi1.inventory_item_id = to_item_id
5541: AND msi1.organization_id = to_org_id);
5542:
5543: --separated out model and option class sections
5544: UPDATE bom_components_b bic
5545: SET bic.optional = 1
5546: WHERE bic.bill_sequence_id = to_sequence_id
5547: AND EXISTS (
5548: SELECT NULL

Line 5631: bom_components_b bic,

5627: brd.attribute13,
5628: brd.attribute14,
5629: brd.attribute15
5630: FROM bom_reference_designators brd,
5631: bom_components_b bic,
5632: bom_copy_explosions_v bev
5633: WHERE bic.bill_sequence_id = to_sequence_id
5634: AND NVL (bic.eco_for_production, 2) = 2
5635: AND brd.component_sequence_id = bic.created_by

Line 5800: bom_components_b bic,

5796: bsc.attribute14,
5797: bsc.attribute15,
5798: bsc.enforce_int_requirements
5799: FROM bom_substitute_components bsc,
5800: bom_components_b bic,
5801: mtl_system_items msi,
5802: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
5803: bom_copy_explosions_v bev
5804: WHERE bic.bill_sequence_id = to_sequence_id

Line 6056: bom_components_b bic,

6052: NULL,
6053: fnd_global.conc_program_id,
6054: sysdate
6055: FROM bom_component_operations bco,
6056: bom_components_b bic,
6057: bom_operation_sequences bos,
6058: bom_copy_explosions_v bev
6059: WHERE bic.bill_sequence_id = to_sequence_id
6060: AND NVL (bic.eco_for_production, 2) = 2

Line 6239: UPDATE bom_components_b bic

6235: IF specific_copy_flag = 'N' THEN
6236: --Turn off trigger BOMTBICX
6237: bom_globals.g_skip_bomtbicx := 'Y';
6238:
6239: UPDATE bom_components_b bic
6240: SET created_by = user_id
6241: WHERE bic.bill_sequence_id = to_sequence_id;
6242:
6243: --Turn on trigger BOMTBICX

Line 6559: FROM bom_components_b bcb

6555: Pass trgt_comps_eff_date and do this validation
6556: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
6557: (
6558: SELECT 1
6559: FROM bom_components_b bcb
6560: WHERE bcb.old_component_sequence_id = bev.component_sequence_id
6561: AND bcb.change_notice = context_eco
6562: AND bcb.acd_type = 3
6563: AND bcb.effectivity_date <= trgt_comps_eff_date

Line 7190: UPDATE bom_components_b bic

7186: IS
7187: BEGIN
7188: bom_globals.g_skip_bomtbicx := 'Y';
7189:
7190: UPDATE bom_components_b bic
7191: SET created_by = p_user_id
7192: WHERE bic.bill_sequence_id = p_to_bill_sequence_id;
7193:
7194: --Turn on trigger BOMTBICX

Line 7442: FROM bom_components_b bcb1,

7438: )
7439: IS
7440: SELECT bcb1.component_sequence_id from_component_seq_id,
7441: bcb2.component_sequence_id to_sequence_id
7442: FROM bom_components_b bcb1,
7443: bom_components_b bcb2
7444: WHERE bcb1.bill_sequence_id = p_from_seq_id
7445: AND bcb1.component_sequence_id = bcb2.created_by
7446: AND bcb2.bill_sequence_id = p_to_seq_id

Line 7443: bom_components_b bcb2

7439: IS
7440: SELECT bcb1.component_sequence_id from_component_seq_id,
7441: bcb2.component_sequence_id to_sequence_id
7442: FROM bom_components_b bcb1,
7443: bom_components_b bcb2
7444: WHERE bcb1.bill_sequence_id = p_from_seq_id
7445: AND bcb1.component_sequence_id = bcb2.created_by
7446: AND bcb2.bill_sequence_id = p_to_seq_id
7447: AND bcb2.component_sequence_id > p_last_copied_comp_seq_id;

Line 7459: bom_components_b bcb

7455: IS
7456: SELECT eec.change_id,
7457: bcb.component_sequence_id
7458: FROM eng_engineering_changes eec,
7459: bom_components_b bcb
7460: WHERE eec.change_notice = p_change_notice
7461: AND eec.organization_id = p_local_org_id
7462: AND bcb.bill_sequence_id = p_bill_seq_id;
7463: CURSOR l_fixed_rev_comp_csr (

Line 7487: FROM bom_components_b bcb

7483: p_bill_seq_id IN NUMBER
7484: )
7485: IS
7486: SELECT max(bcb.component_sequence_id)
7487: FROM bom_components_b bcb
7488: WHERE bcb.bill_sequence_id = p_bill_seq_id;
7489:
7490: CURSOR C_DATA_LEVEL(p_data_level_name VARCHAR2) IS
7491: SELECT DATA_LEVEL_ID

Line 7761: INSERT INTO bom_components_b

7757:
7758: IF l_from_eff_ctrl = 1 AND l_to_eff_ctrl = 1 THEN -- Date - Date
7759:
7760:
7761: INSERT INTO bom_components_b
7762: (shipping_allowed,
7763: required_to_ship,
7764: required_for_revenue,
7765: include_on_ship_docs,

Line 8015: FROM bom_components_b bic,

8011: THEN 0
8012: ELSE
8013: to_number(NULL)
8014: END AS to_minor_revision_id
8015: FROM bom_components_b bic,
8016: mtl_system_items msi,
8017: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8018: bom_copy_explosions_v bev
8019: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 8047: FROM bom_components_b bcb

8043: )
8044: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
8045: (
8046: SELECT 1
8047: FROM bom_components_b bcb
8048: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
8049: AND bcb.change_notice = context_eco
8050: AND bcb.acd_type = 3
8051: AND bcb.effectivity_date <= x_effectivity_date

Line 8130: INSERT INTO bom_components_b

8126: OR ( l_from_eff_ctrl = 3 AND l_to_eff_ctrl = 3 ) -- Serial
8127: ) THEN
8128:
8129:
8130: INSERT INTO bom_components_b
8131: (shipping_allowed,
8132: required_to_ship,
8133: required_for_revenue,
8134: include_on_ship_docs,

Line 8384: FROM bom_components_b bic,

8380: THEN 0
8381: ELSE
8382: to_number(NULL)
8383: END AS to_minor_revision_id
8384: FROM bom_components_b bic,
8385: mtl_system_items msi,
8386: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8387: bom_copy_explosions_v bev
8388: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 8416: FROM bom_components_b bcb

8412: )
8413: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
8414: (
8415: SELECT 1
8416: FROM bom_components_b bcb
8417: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
8418: AND bcb.change_notice = context_eco
8419: AND bcb.acd_type = 3
8420: AND bcb.effectivity_date <= x_effectivity_date

Line 8497: INSERT INTO bom_components_b

8493: );
8494: ELSIF l_from_eff_ctrl = 4 AND l_to_eff_ctrl = 4 THEN -- Rev - Rev
8495:
8496:
8497: INSERT INTO bom_components_b
8498: (shipping_allowed,
8499: required_to_ship,
8500: required_for_revenue,
8501: include_on_ship_docs,

Line 8786: FROM bom_components_b bic,

8782: THEN 0
8783: ELSE
8784: to_number(NULL)
8785: END AS to_minor_revision_id
8786: FROM bom_components_b bic,
8787: mtl_system_items msi,
8788: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8789: bom_copy_explosions_v bev
8790: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 8818: FROM bom_components_b bcb

8814: )
8815: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
8816: (
8817: SELECT 1
8818: FROM bom_components_b bcb
8819: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
8820: AND bcb.change_notice = context_eco
8821: AND bcb.acd_type = 3
8822: AND bcb.effectivity_date <= x_effectivity_date

Line 8909: INSERT INTO bom_components_b

8905: );
8906: ELSIF l_from_eff_ctrl = 4 AND l_to_eff_ctrl = 1 THEN -- Rev - Date
8907:
8908:
8909: INSERT INTO bom_components_b
8910: (shipping_allowed,
8911: required_to_ship,
8912: required_for_revenue,
8913: include_on_ship_docs,

Line 9185: FROM bom_components_b bic,

9181: THEN 0
9182: ELSE
9183: to_number(NULL)
9184: END AS to_minor_revision_id
9185: FROM bom_components_b bic,
9186: mtl_system_items msi,
9187: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9188: bom_copy_explosions_v bev
9189: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 9217: FROM bom_components_b bcb

9213: )
9214: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
9215: (
9216: SELECT 1
9217: FROM bom_components_b bcb
9218: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
9219: AND bcb.change_notice = context_eco
9220: AND bcb.acd_type = 3
9221: AND bcb.effectivity_date <= x_effectivity_date

Line 9310: INSERT INTO bom_components_b

9306: );
9307: ELSIF l_from_eff_ctrl = 1 AND l_to_eff_ctrl = 4 THEN -- Date - Rev
9308:
9309:
9310: INSERT INTO bom_components_b
9311: (shipping_allowed,
9312: required_to_ship,
9313: required_for_revenue,
9314: include_on_ship_docs,

Line 9585: FROM bom_components_b bic,

9581: THEN 0
9582: ELSE
9583: to_number(NULL)
9584: END AS to_minor_revision_id
9585: FROM bom_components_b bic,
9586: mtl_system_items msi,
9587: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9588: bom_copy_explosions_v bev
9589: WHERE bic.bill_sequence_id = x_from_sequence_id

Line 9617: FROM bom_components_b bcb

9613: )
9614: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
9615: (
9616: SELECT 1
9617: FROM bom_components_b bcb
9618: WHERE bcb.old_component_sequence_id = bic.component_sequence_id
9619: AND bcb.change_notice = context_eco
9620: AND bcb.acd_type = 3
9621: AND bcb.effectivity_date <= x_effectivity_date

Line 9789: FROM bom_components_b bcb,

9785: END IF;
9786:
9787: SELECT COUNT (*)
9788: INTO l_no_access_comp_cnt
9789: FROM bom_components_b bcb,
9790: mtl_system_items_b_kfv msbk1,
9791: bom_copy_explosions_v bev
9792: WHERE bcb.bill_sequence_id = x_from_sequence_id
9793: AND bcb.component_item_id = msbk1.inventory_item_id

Line 9815: FROM bom_components_b bcb1

9811: )
9812: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
9813: (
9814: SELECT 1
9815: FROM bom_components_b bcb1
9816: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
9817: AND bcb1.change_notice = context_eco
9818: AND bcb1.acd_type = 3
9819: AND bcb1.effectivity_date <= x_effectivity_date

Line 9890: FROM bom_components_b bcb,

9886: fnd_global.conc_request_id,
9887: NULL,
9888: fnd_global.conc_program_id,
9889: sysdate
9890: FROM bom_components_b bcb,
9891: mtl_system_items_b_kfv msbk1,
9892: bom_copy_explosions_v bev
9893: WHERE msbk1.inventory_item_id = from_item_id
9894: AND msbk1.organization_id = from_org_id

Line 9918: FROM bom_components_b bcb,

9914: IF (from_org_id <> to_org_id)
9915: THEN
9916: SELECT COUNT (*)
9917: INTO l_no_access_comp_cnt
9918: FROM bom_components_b bcb,
9919: mtl_system_items_b_kfv msbk1,
9920: bom_copy_explosions_v bev
9921: WHERE bcb.bill_sequence_id = x_from_sequence_id
9922: AND bcb.component_item_id = msbk1.inventory_item_id

Line 9944: FROM bom_components_b bcb1

9940: )
9941: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
9942: (
9943: SELECT 1
9944: FROM bom_components_b bcb1
9945: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
9946: AND bcb1.change_notice = context_eco
9947: AND bcb1.acd_type = 3
9948: AND bcb1.effectivity_date <= x_effectivity_date

Line 10019: FROM bom_components_b bcb,

10015: fnd_global.conc_request_id,
10016: NULL,
10017: fnd_global.conc_program_id,
10018: sysdate
10019: FROM bom_components_b bcb,
10020: mtl_system_items_b_kfv msbk1,
10021: bom_copy_explosions_v bev
10022: WHERE msbk1.inventory_item_id = from_item_id
10023: AND msbk1.organization_id = from_org_id

Line 10084: FROM bom_components_b bcb,

10080: fnd_global.conc_request_id,
10081: NULL,
10082: fnd_global.conc_program_id,
10083: sysdate
10084: FROM bom_components_b bcb,
10085: mtl_system_items_b msib1, -- component
10086: bom_copy_explosions_v bev
10087: WHERE bcb.bill_sequence_id = x_from_sequence_id
10088: AND bcb.component_item_id = msib1.inventory_item_id

Line 10105: FROM bom_components_b bcb1

10101: )
10102: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
10103: (
10104: SELECT 1
10105: FROM bom_components_b bcb1
10106: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
10107: AND bcb1.change_notice = context_eco
10108: AND bcb1.acd_type = 3
10109: AND bcb1.effectivity_date <= x_effectivity_date

Line 10186: FROM bom_components_b bcb,

10182: fnd_global.conc_request_id,
10183: NULL,
10184: fnd_global.conc_program_id,
10185: sysdate
10186: FROM bom_components_b bcb,
10187: bom_copy_explosions_v bev
10188: WHERE bcb.bill_sequence_id = x_from_sequence_id
10189: AND bcb.component_item_id <> to_item_id
10190: AND bcb.eco_for_production <> 2

Line 10203: FROM bom_components_b bcb1

10199: )
10200: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
10201: (
10202: SELECT 1
10203: FROM bom_components_b bcb1
10204: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
10205: AND bcb1.change_notice = context_eco
10206: AND bcb1.acd_type = 3
10207: AND bcb1.effectivity_date <= x_effectivity_date

Line 10285: FROM bom_components_b bcb,

10281: fnd_global.conc_request_id,
10282: NULL,
10283: fnd_global.conc_program_id,
10284: sysdate
10285: FROM bom_components_b bcb,
10286: mtl_system_items_b msib1,
10287: bom_copy_explosions_v bev
10288: WHERE bcb.bill_sequence_id = x_from_sequence_id
10289: AND bcb.component_item_id = msib1.inventory_item_id

Line 10305: FROM bom_components_b bcb1

10301: )
10302: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
10303: (
10304: SELECT 1
10305: FROM bom_components_b bcb1
10306: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
10307: AND bcb1.change_notice = context_eco
10308: AND bcb1.acd_type = 3
10309: AND bcb1.effectivity_date <= x_effectivity_date

Line 10385: FROM bom_components_b bcb,

10381: fnd_global.conc_request_id,
10382: NULL,
10383: fnd_global.conc_program_id,
10384: sysdate
10385: FROM bom_components_b bcb,
10386: bom_copy_explosions_v bev
10387: WHERE bcb.bill_sequence_id = x_from_sequence_id
10388: AND bcb.component_item_id <> to_item_id
10389: AND bcb.implementation_date IS NOT NULL

Line 10402: FROM bom_components_b bcb1

10398: )
10399: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
10400: (
10401: SELECT 1
10402: FROM bom_components_b bcb1
10403: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
10404: AND bcb1.change_notice = context_eco
10405: AND bcb1.acd_type = 3
10406: AND bcb1.effectivity_date <= x_effectivity_date

Line 10488: FROM bom_components_b bcb,

10484: fnd_global.conc_request_id,
10485: NULL,
10486: fnd_global.conc_program_id,
10487: sysdate
10488: FROM bom_components_b bcb,
10489: mtl_system_items_b msib
10490: WHERE bcb.bill_sequence_id = to_sequence_id
10491: AND bcb.component_item_id = msib.inventory_item_id
10492: AND msib.organization_id = to_org_id

Line 10553: FROM bom_components_b bcb,

10549: fnd_global.conc_request_id,
10550: NULL,
10551: fnd_global.conc_program_id,
10552: sysdate
10553: FROM bom_components_b bcb,
10554: mtl_system_items_b msib
10555: WHERE bcb.bill_sequence_id = to_sequence_id
10556: AND bcb.component_item_id = msib.inventory_item_id
10557: AND msib.organization_id = to_org_id

Line 10628: FROM bom_components_b bcb,

10624: fnd_global.conc_request_id,
10625: NULL,
10626: fnd_global.conc_program_id,
10627: sysdate
10628: FROM bom_components_b bcb,
10629: bom_copy_explosions_v bev
10630: WHERE bcb.bill_sequence_id = x_from_sequence_id
10631: AND bcb.component_item_id <> to_item_id
10632: AND bcb.implementation_date IS NOT NULL

Line 10647: FROM bom_components_b bcb1

10643: )
10644: AND NOT EXISTS -- Bug 5151332 Disabled components should not get copied in ECO context
10645: (
10646: SELECT 1
10647: FROM bom_components_b bcb1
10648: WHERE bcb1.old_component_sequence_id = bcb.component_sequence_id
10649: AND bcb1.change_notice = context_eco
10650: AND bcb1.acd_type = 3
10651: AND bcb1.effectivity_date <= x_effectivity_date

Line 10814: FROM bom_components_b bcb

10810: ELSIF l_to_eff_ctrl = 4
10811: THEN
10812: SELECT COUNT (*)
10813: INTO dummy
10814: FROM bom_components_b bcb
10815: WHERE bcb.bill_sequence_id = to_sequence_id
10816: AND EXISTS (
10817: SELECT NULL
10818: FROM bom_components_b bcb2

Line 10818: FROM bom_components_b bcb2

10814: FROM bom_components_b bcb
10815: WHERE bcb.bill_sequence_id = to_sequence_id
10816: AND EXISTS (
10817: SELECT NULL
10818: FROM bom_components_b bcb2
10819: WHERE bcb2.bill_sequence_id = to_sequence_id
10820: AND bcb2.ROWID <> bcb.ROWID
10821: AND bcb2.operation_seq_num = bcb.operation_seq_num
10822: AND bcb2.component_item_id = bcb.component_item_id

Line 10959: FROM bom_components_b bcb,

10955: fnd_global.conc_request_id,
10956: NULL,
10957: fnd_global.conc_program_id,
10958: sysdate
10959: FROM bom_components_b bcb,
10960: mtl_system_items_b msib1,
10961: mtl_system_items_b msib2
10962: WHERE bcb.bill_sequence_id = to_sequence_id
10963: AND (msib1.bom_item_type = planning

Line 11013: FROM bom_components_b bcb,

11009: fnd_global.conc_request_id,
11010: NULL,
11011: fnd_global.conc_program_id,
11012: sysdate
11013: FROM bom_components_b bcb,
11014: mtl_system_items_b msib1,
11015: mtl_system_items_b msib2
11016: WHERE bcb.bill_sequence_id = to_sequence_id
11017: AND (msib1.bom_item_type IN (model, option_class)

Line 11068: FROM bom_components_b bcb,

11064: fnd_global.conc_request_id,
11065: NULL,
11066: fnd_global.conc_program_id,
11067: sysdate
11068: FROM bom_components_b bcb,
11069: mtl_system_items_b msib1, -- Comp
11070: mtl_system_items_b msib2 -- Structure
11071: WHERE bcb.bill_sequence_id = to_sequence_id
11072: AND (msib1.replenish_to_order_flag = 'Y'

Line 11123: FROM bom_components_b bcb,

11119: fnd_global.conc_request_id,
11120: NULL,
11121: fnd_global.conc_program_id,
11122: sysdate
11123: FROM bom_components_b bcb,
11124: mtl_system_items_b msib1, -- Comp
11125: mtl_system_items_b msib2 -- Structure
11126: WHERE bcb.bill_sequence_id = to_sequence_id
11127: AND (msib1.replenish_to_order_flag = 'Y'

Line 11179: FROM bom_components_b bcb,

11175: fnd_global.conc_request_id,
11176: NULL,
11177: fnd_global.conc_program_id,
11178: sysdate
11179: FROM bom_components_b bcb,
11180: mtl_system_items_b msib1, -- Comp
11181: mtl_system_items_b msib2 -- Structure
11182: WHERE bcb.bill_sequence_id = to_sequence_id
11183: AND (msib1.pick_components_flag = 'Y'

Line 11231: UPDATE bom_components_b bic

11227: sql_stmt_num := 43;
11228: --Turn off trigger BOMTBICX
11229: bom_globals.g_skip_bomtbicx := 'Y';
11230:
11231: UPDATE bom_components_b bic
11232: SET bic.wip_supply_type = phantom
11233: WHERE bic.bill_sequence_id = to_sequence_id
11234: AND EXISTS (
11235: SELECT NULL

Line 11249: UPDATE bom_components_b bic

11245: bom_globals.g_skip_bomtbicx := 'N';
11246: sql_stmt_num := 44;
11247: bom_globals.g_skip_bomtbicx := 'Y';
11248:
11249: UPDATE bom_components_b bic
11250: SET bic.optional = 1
11251: WHERE bic.bill_sequence_id = to_sequence_id
11252: AND EXISTS (
11253: SELECT NULL

Line 11334: bom_components_b bic,

11330: brd.attribute13,
11331: brd.attribute14,
11332: brd.attribute15
11333: FROM bom_reference_designators brd,
11334: bom_components_b bic,
11335: bom_copy_explosions_v bev
11336: WHERE bic.bill_sequence_id = to_sequence_id
11337: AND NVL (bic.eco_for_production, 2) = 2
11338: AND brd.component_sequence_id = bic.created_by

Line 11424: bom_components_b bic,

11420: bsc.attribute14,
11421: bsc.attribute15,
11422: bsc.enforce_int_requirements
11423: FROM bom_substitute_components bsc,
11424: bom_components_b bic,
11425: mtl_system_items msi,
11426: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
11427: bom_copy_explosions_v bev
11428: WHERE bic.bill_sequence_id = to_sequence_id

Line 11574: bom_components_b bic,

11570: NULL,
11571: fnd_global.conc_program_id,
11572: sysdate
11573: FROM bom_component_operations bco,
11574: bom_components_b bic,
11575: bom_operation_sequences bos,
11576: bom_copy_explosions_v bev
11577: WHERE bic.bill_sequence_id = to_sequence_id
11578: AND NVL (bic.eco_for_production, 2) = 2