[Home] [Help]
570: -- for the components which are getting copied. Components from effectivity boundary.
571: trgt_comps_eff_date IN DATE DEFAULT NULL,
572: trgt_comps_unit_number IN VARCHAR2 DEFAULT NULL,
573: trgt_comps_end_item_rev_id IN NUMBER DEFAULT NULL,
574: -- Since the JOIN occurs with bom_copy_explosions_v, there could be multiple
575: -- sub-assemblies (items) in the exploded structure at different levels
576: -- but if we copy once that will be suffice
577: p_parent_sort_order IN VARCHAR2 DEFAULT NULL,
578: p_cpy_disable_fields IN VARCHAR2 DEFAULT 'N',
961: p_parent_sort_order IN VARCHAR2
962: )
963: IS
964: SELECT bev.comp_fixed_rev_code
965: FROM bom_copy_explosions_v bev
966: WHERE bev.sort_order = p_parent_sort_order;
967: CURSOR l_eff_date_for_rev_csr (
968: p_inventory_item_id IN NUMBER,
969: p_organization_id IN NUMBER,
1680: END AS to_minor_revision_id
1681: FROM bom_components_b bic,
1682: mtl_system_items msi,
1683: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
1684: bom_copy_explosions_v bev
1685: WHERE bic.bill_sequence_id = x_from_sequence_id
1686: AND bic.component_item_id = msi.inventory_item_id
1687: AND bic.component_item_id <> to_item_id
1688: AND NVL (bic.eco_for_production, 2) = 2
2079: END AS to_minor_revision_id
2080: FROM bom_components_b bic,
2081: mtl_system_items msi,
2082: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2083: bom_copy_explosions_v bev
2084: WHERE bic.bill_sequence_id = x_from_sequence_id
2085: AND bic.component_item_id = msi.inventory_item_id
2086: AND bic.component_item_id <> to_item_id
2087: AND NVL (bic.eco_for_production, 2) = 2
2556: END AS to_minor_revision_id
2557: FROM bom_components_b bic,
2558: mtl_system_items msi,
2559: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2560: bom_copy_explosions_v bev
2561: WHERE bic.bill_sequence_id = x_from_sequence_id
2562: AND bic.component_item_id = msi.inventory_item_id
2563: AND bic.component_item_id <> to_item_id
2564: AND NVL (bic.eco_for_production, 2) = 2
2998: END AS to_minor_revision_id
2999: FROM bom_components_b bic,
3000: mtl_system_items msi,
3001: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3002: bom_copy_explosions_v bev
3003: WHERE bic.bill_sequence_id = x_from_sequence_id
3004: AND bic.component_item_id = msi.inventory_item_id
3005: AND bic.component_item_id <> to_item_id
3006: AND NVL (bic.eco_for_production, 2) = 2
3447: END AS to_minor_revision_id
3448: FROM bom_components_b bic,
3449: mtl_system_items msi,
3450: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3451: bom_copy_explosions_v bev
3452: WHERE bic.bill_sequence_id = x_from_sequence_id
3453: AND bic.component_item_id = msi.inventory_item_id
3454: AND bic.component_item_id <> to_item_id
3455: AND NVL (bic.eco_for_production, 2) = 2
3752: SELECT COUNT (*)
3753: INTO l_no_access_comp_cnt
3754: FROM bom_components_b bcb,
3755: mtl_system_items_b_kfv msbk1,
3756: bom_copy_explosions_v bev
3757: WHERE bcb.bill_sequence_id = x_from_sequence_id
3758: AND bcb.component_item_id = msbk1.inventory_item_id
3759: AND bcb.component_item_id <> to_item_id
3760: AND 'T' <>
3849: SELECT COUNT (*)
3850: INTO l_no_access_comp_cnt
3851: FROM bom_components_b bcb,
3852: mtl_system_items_b_kfv msbk1,
3853: bom_copy_explosions_v bev
3854: WHERE bcb.bill_sequence_id = x_from_sequence_id
3855: AND bcb.component_item_id = msbk1.inventory_item_id
3856: AND bcb.component_item_id <> to_item_id
3857: AND 'T' <>
3984: fnd_global.conc_program_id,
3985: sysdate
3986: FROM bom_components_b bcb,
3987: mtl_system_items_b msib, -- component
3988: bom_copy_explosions_v bev
3989: WHERE bcb.bill_sequence_id = x_from_sequence_id
3990: AND bcb.component_item_id = msib.inventory_item_id
3991: AND bcb.component_item_id <> to_item_id
3992: AND msib.organization_id = to_org_id
4072: NULL,
4073: fnd_global.conc_program_id,
4074: sysdate
4075: FROM bom_components_b bcb,
4076: bom_copy_explosions_v bev
4077: WHERE bcb.bill_sequence_id = x_from_sequence_id
4078: AND bcb.component_item_id <> to_item_id
4079: AND bcb.eco_for_production <> 2
4080: AND bcb.component_sequence_id = bev.component_sequence_id
4156: 'E'
4157: FROM bom_components_b bcb,
4158: mtl_system_items_b_kfv msbk1,
4159: mtl_system_items_b_kfv msbk2,
4160: bom_copy_explosions_v bev
4161: WHERE bcb.bill_sequence_id = x_from_sequence_id
4162: AND bcb.component_item_id = msbk1.inventory_item_id
4163: AND bcb.component_item_id <> to_item_id
4164: AND bcb.implementation_date IS NULL
4212: fnd_global.conc_program_id,
4213: sysdate
4214: FROM bom_components_b bcb,
4215: mtl_system_items_b msib,
4216: bom_copy_explosions_v bev
4217: WHERE bcb.bill_sequence_id = x_from_sequence_id
4218: AND bcb.component_item_id = msib.inventory_item_id
4219: AND bcb.component_item_id <> to_item_id
4220: AND bcb.implementation_date IS NOT NULL
4298: NULL,
4299: fnd_global.conc_program_id,
4300: sysdate
4301: FROM bom_components_b bcb,
4302: bom_copy_explosions_v bev
4303: WHERE bcb.bill_sequence_id = x_from_sequence_id
4304: AND bcb.component_item_id <> to_item_id
4305: AND bcb.implementation_date IS NOT NULL
4306: AND bcb.component_sequence_id = bev.component_sequence_id
4533: NULL,
4534: fnd_global.conc_program_id,
4535: sysdate
4536: FROM bom_components_b bcb,
4537: bom_copy_explosions_v bev
4538: WHERE bcb.bill_sequence_id = x_from_sequence_id
4539: AND bcb.component_item_id <> to_item_id
4540: AND bcb.implementation_date IS NOT NULL
4541: AND bcb.component_sequence_id = bev.component_sequence_id
5537: brd.attribute14,
5538: brd.attribute15
5539: FROM bom_reference_designators brd,
5540: bom_components_b bic,
5541: bom_copy_explosions_v bev
5542: WHERE bic.bill_sequence_id = to_sequence_id
5543: AND NVL (bic.eco_for_production, 2) = 2
5544: AND brd.component_sequence_id = bic.created_by
5545: AND NVL (brd.acd_type, 1) <> 3
5708: FROM bom_substitute_components bsc,
5709: bom_components_b bic,
5710: mtl_system_items msi,
5711: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
5712: bom_copy_explosions_v bev
5713: WHERE bic.bill_sequence_id = to_sequence_id
5714: AND NVL (bic.eco_for_production, 2) = 2
5715: AND bsc.component_sequence_id = bic.created_by
5716: AND NVL (bsc.acd_type, 1) <> 3
5958: sysdate
5959: FROM bom_component_operations bco,
5960: bom_components_b bic,
5961: bom_operation_sequences bos,
5962: bom_copy_explosions_v bev
5963: WHERE bic.bill_sequence_id = to_sequence_id
5964: AND NVL (bic.eco_for_production, 2) = 2
5965: AND bco.component_sequence_id = bic.created_by
5966: AND bos.routing_sequence_id = to_rtg_seq_id
6299: c_explode_group_id IN NUMBER
6300: )
6301: IS
6302: SELECT component_item_id
6303: FROM bom_copy_explosions_v bs
6304: WHERE bs.sort_order <> c_sort_order
6305: AND bs.GROUP_ID = c_explode_group_id
6306: START WITH bs.sort_order = c_sort_order
6307: AND bs.GROUP_ID = c_explode_group_id
6445: msibk.secondary_default_ind,
6446: msibk.tracking_quantity_ind,
6447: msibk.ont_pricing_qty_source
6448: FROM mtl_system_items_b_kfv msibk,
6449: bom_copy_explosions_v bev
6450: WHERE msibk.inventory_item_id = bev.component_item_id
6451: AND msibk.organization_id = bev.organization_id
6452: AND (bev.implementation_date IS NOT NULL
6453: OR (bev.implementation_date IS NULL
6485: )
6486: OR NOT EXISTS (
6487: -- Structure Action is exclude
6488: SELECT 1
6489: FROM bom_copy_structure_actions bcsa, bom_copy_explosions_v bcev
6490: WHERE bcsa.copy_request_id = p_copy_request_id
6491: AND bcsa.organization_id = p_to_org_id
6492: AND bcsa.structure_exception_action = 1
6493: AND bcsa.component_sequence_id = bcev.component_sequence_id
7129: eco_end_item_rev_id IN NUMBER DEFAULT NULL,
7130: -- Structure has been exploded in context of this ECO for copying
7131: context_eco IN VARCHAR2 DEFAULT NULL,
7132: p_end_item_rev_id IN NUMBER DEFAULT NULL,
7133: -- Since the JOIN occurs with bom_copy_explosions_v, there could be multiple
7134: -- sub-assemblies (items) in the exploded structure at different levels
7135: -- but if we copy once that will be suffice
7136: p_parent_sort_order IN VARCHAR2 DEFAULT NULL,
7137: p_trgt_str_eff_ctrl IN NUMBER DEFAULT 1,
7364: p_parent_sort_order IN VARCHAR2
7365: )
7366: IS
7367: SELECT bev.comp_fixed_rev_code
7368: FROM bom_copy_explosions_v bev
7369: WHERE bev.sort_order = p_parent_sort_order;
7370: CURSOR l_eff_date_for_rev_csr (
7371: p_inventory_item_id IN NUMBER,
7372: p_organization_id IN NUMBER,
7873: END AS to_minor_revision_id
7874: FROM bom_components_b bic,
7875: mtl_system_items msi,
7876: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
7877: bom_copy_explosions_v bev
7878: WHERE bic.bill_sequence_id = x_from_sequence_id
7879: AND bic.component_item_id = msi.inventory_item_id
7880: AND bic.component_item_id <> to_item_id
7881: AND NVL (bic.eco_for_production, 2) = 2
8242: END AS to_minor_revision_id
8243: FROM bom_components_b bic,
8244: mtl_system_items msi,
8245: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8246: bom_copy_explosions_v bev
8247: WHERE bic.bill_sequence_id = x_from_sequence_id
8248: AND bic.component_item_id = msi.inventory_item_id
8249: AND bic.component_item_id <> to_item_id
8250: AND NVL (bic.eco_for_production, 2) = 2
8643: END AS to_minor_revision_id
8644: FROM bom_components_b bic,
8645: mtl_system_items msi,
8646: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8647: bom_copy_explosions_v bev
8648: WHERE bic.bill_sequence_id = x_from_sequence_id
8649: AND bic.component_item_id = msi.inventory_item_id
8650: AND bic.component_item_id <> to_item_id
8651: AND NVL (bic.eco_for_production, 2) = 2
9041: END AS to_minor_revision_id
9042: FROM bom_components_b bic,
9043: mtl_system_items msi,
9044: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9045: bom_copy_explosions_v bev
9046: WHERE bic.bill_sequence_id = x_from_sequence_id
9047: AND bic.component_item_id = msi.inventory_item_id
9048: AND bic.component_item_id <> to_item_id
9049: AND NVL (bic.eco_for_production, 2) = 2
9440: END AS to_minor_revision_id
9441: FROM bom_components_b bic,
9442: mtl_system_items msi,
9443: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9444: bom_copy_explosions_v bev
9445: WHERE bic.bill_sequence_id = x_from_sequence_id
9446: AND bic.component_item_id = msi.inventory_item_id
9447: AND bic.component_item_id <> to_item_id
9448: AND NVL (bic.eco_for_production, 2) = 2
9634: SELECT COUNT (*)
9635: INTO l_no_access_comp_cnt
9636: FROM bom_components_b bcb,
9637: mtl_system_items_b_kfv msbk1,
9638: bom_copy_explosions_v bev
9639: WHERE bcb.bill_sequence_id = x_from_sequence_id
9640: AND bcb.component_item_id = msbk1.inventory_item_id
9641: AND bcb.component_item_id <> to_item_id
9642: AND 'T' <>
9735: fnd_global.conc_program_id,
9736: sysdate
9737: FROM bom_components_b bcb,
9738: mtl_system_items_b_kfv msbk1,
9739: bom_copy_explosions_v bev
9740: WHERE msbk1.inventory_item_id = from_item_id
9741: AND msbk1.organization_id = from_org_id
9742: AND bcb.component_sequence_id = bev.component_sequence_id
9743: AND bev.bill_sequence_id = from_sequence_id
9763: SELECT COUNT (*)
9764: INTO l_no_access_comp_cnt
9765: FROM bom_components_b bcb,
9766: mtl_system_items_b_kfv msbk1,
9767: bom_copy_explosions_v bev
9768: WHERE bcb.bill_sequence_id = x_from_sequence_id
9769: AND bcb.component_item_id = msbk1.inventory_item_id
9770: AND bcb.component_item_id <> to_item_id
9771: AND 'T' <>
9864: fnd_global.conc_program_id,
9865: sysdate
9866: FROM bom_components_b bcb,
9867: mtl_system_items_b_kfv msbk1,
9868: bom_copy_explosions_v bev
9869: WHERE msbk1.inventory_item_id = from_item_id
9870: AND msbk1.organization_id = from_org_id
9871: AND bcb.component_sequence_id = bev.component_sequence_id
9872: AND bev.bill_sequence_id = from_sequence_id
9929: fnd_global.conc_program_id,
9930: sysdate
9931: FROM bom_components_b bcb,
9932: mtl_system_items_b msib1, -- component
9933: bom_copy_explosions_v bev
9934: WHERE bcb.bill_sequence_id = x_from_sequence_id
9935: AND bcb.component_item_id = msib1.inventory_item_id
9936: AND bcb.component_item_id <> to_item_id
9937: AND msib1.organization_id = to_org_id
10030: NULL,
10031: fnd_global.conc_program_id,
10032: sysdate
10033: FROM bom_components_b bcb,
10034: bom_copy_explosions_v bev
10035: WHERE bcb.bill_sequence_id = x_from_sequence_id
10036: AND bcb.component_item_id <> to_item_id
10037: AND bcb.eco_for_production <> 2
10038: AND bcb.component_sequence_id = bev.component_sequence_id
10130: fnd_global.conc_program_id,
10131: sysdate
10132: FROM bom_components_b bcb,
10133: mtl_system_items_b msib1,
10134: bom_copy_explosions_v bev
10135: WHERE bcb.bill_sequence_id = x_from_sequence_id
10136: AND bcb.component_item_id = msib1.inventory_item_id
10137: AND bcb.component_item_id <> to_item_id
10138: AND bcb.implementation_date IS NOT NULL
10229: NULL,
10230: fnd_global.conc_program_id,
10231: sysdate
10232: FROM bom_components_b bcb,
10233: bom_copy_explosions_v bev
10234: WHERE bcb.bill_sequence_id = x_from_sequence_id
10235: AND bcb.component_item_id <> to_item_id
10236: AND bcb.implementation_date IS NOT NULL
10237: AND bcb.component_sequence_id = bev.component_sequence_id
10472: NULL,
10473: fnd_global.conc_program_id,
10474: sysdate
10475: FROM bom_components_b bcb,
10476: bom_copy_explosions_v bev
10477: WHERE bcb.bill_sequence_id = x_from_sequence_id
10478: AND bcb.component_item_id <> to_item_id
10479: AND bcb.implementation_date IS NOT NULL
10480: AND bcb.component_sequence_id = bev.component_sequence_id
11178: brd.attribute14,
11179: brd.attribute15
11180: FROM bom_reference_designators brd,
11181: bom_components_b bic,
11182: bom_copy_explosions_v bev
11183: WHERE bic.bill_sequence_id = to_sequence_id
11184: AND NVL (bic.eco_for_production, 2) = 2
11185: AND brd.component_sequence_id = bic.created_by
11186: AND NVL (brd.acd_type, 1) <> 3
11270: FROM bom_substitute_components bsc,
11271: bom_components_b bic,
11272: mtl_system_items msi,
11273: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
11274: bom_copy_explosions_v bev
11275: WHERE bic.bill_sequence_id = to_sequence_id
11276: AND NVL (bic.eco_for_production, 2) = 2
11277: AND bsc.component_sequence_id = bic.created_by
11278: AND NVL (bsc.acd_type, 1) <> 3
11419: sysdate
11420: FROM bom_component_operations bco,
11421: bom_components_b bic,
11422: bom_operation_sequences bos,
11423: bom_copy_explosions_v bev
11424: WHERE bic.bill_sequence_id = to_sequence_id
11425: AND NVL (bic.eco_for_production, 2) = 2
11426: AND bco.component_sequence_id = bic.created_by
11427: AND bos.routing_sequence_id = to_rtg_seq_id