[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',
965: p_parent_sort_order IN VARCHAR2
966: )
967: IS
968: SELECT bev.comp_fixed_rev_code
969: FROM bom_copy_explosions_v bev
970: WHERE bev.sort_order = p_parent_sort_order;
971: CURSOR l_eff_date_for_rev_csr (
972: p_inventory_item_id IN NUMBER,
973: p_organization_id IN NUMBER,
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
1738: AND bic.component_item_id = msi.inventory_item_id
1739: AND bic.component_item_id <> to_item_id
1740: AND NVL (bic.eco_for_production, 2) = 2
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
2138: AND bic.component_item_id = msi.inventory_item_id
2139: AND bic.component_item_id <> to_item_id
2140: AND NVL (bic.eco_for_production, 2) = 2
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
2615: AND bic.component_item_id = msi.inventory_item_id
2616: AND bic.component_item_id <> to_item_id
2617: AND NVL (bic.eco_for_production, 2) = 2
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
3057: AND bic.component_item_id = msi.inventory_item_id
3058: AND bic.component_item_id <> to_item_id
3059: AND NVL (bic.eco_for_production, 2) = 2
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
3507: AND bic.component_item_id = msi.inventory_item_id
3508: AND bic.component_item_id <> to_item_id
3509: AND NVL (bic.eco_for_production, 2) = 2
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
3821: AND bcb.component_item_id <> to_item_id
3822: AND 'T' <>
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
3918: AND bcb.component_item_id <> to_item_id
3919: AND 'T' <>
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
4053: AND bcb.component_item_id <> to_item_id
4054: AND msib.organization_id = to_org_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
4142: AND bcb.component_sequence_id = bev.component_sequence_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
4224: AND bcb.component_item_id = msbk1.inventory_item_id
4225: AND bcb.component_item_id <> to_item_id
4226: AND bcb.implementation_date IS 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
4281: AND bcb.component_item_id <> to_item_id
4282: AND bcb.implementation_date IS NOT NULL
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
4368: AND bcb.component_sequence_id = bev.component_sequence_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
4603: AND bcb.component_sequence_id = bev.component_sequence_id
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
5636: AND NVL (brd.acd_type, 1) <> 3
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
5805: AND NVL (bic.eco_for_production, 2) = 2
5806: AND bsc.component_sequence_id = bic.created_by
5807: AND NVL (bsc.acd_type, 1) <> 3
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
6061: AND bco.component_sequence_id = bic.created_by
6062: AND bos.routing_sequence_id = to_rtg_seq_id
6395: c_explode_group_id IN NUMBER
6396: )
6397: IS
6398: SELECT component_item_id
6399: FROM bom_copy_explosions_v bs
6400: WHERE bs.sort_order <> c_sort_order
6401: AND bs.GROUP_ID = c_explode_group_id
6402: START WITH bs.sort_order = c_sort_order
6403: AND bs.GROUP_ID = c_explode_group_id
6541: msibk.secondary_default_ind,
6542: msibk.tracking_quantity_ind,
6543: msibk.ont_pricing_qty_source
6544: FROM mtl_system_items_b_kfv msibk,
6545: bom_copy_explosions_v bev
6546: WHERE msibk.inventory_item_id = bev.component_item_id
6547: AND msibk.organization_id = bev.organization_id
6548: AND (bev.implementation_date IS NOT NULL
6549: OR (bev.implementation_date IS NULL
6581: )
6582: OR NOT EXISTS (
6583: -- Structure Action is exclude
6584: SELECT 1
6585: FROM bom_copy_structure_actions bcsa, bom_copy_explosions_v bcev
6586: WHERE bcsa.copy_request_id = p_copy_request_id
6587: AND bcsa.organization_id = p_to_org_id
6588: AND bcsa.structure_exception_action = 1
6589: AND bcsa.component_sequence_id = bcev.component_sequence_id
7225: eco_end_item_rev_id IN NUMBER DEFAULT NULL,
7226: -- Structure has been exploded in context of this ECO for copying
7227: context_eco IN VARCHAR2 DEFAULT NULL,
7228: p_end_item_rev_id IN NUMBER DEFAULT NULL,
7229: -- Since the JOIN occurs with bom_copy_explosions_v, there could be multiple
7230: -- sub-assemblies (items) in the exploded structure at different levels
7231: -- but if we copy once that will be suffice
7232: p_parent_sort_order IN VARCHAR2 DEFAULT NULL,
7233: p_trgt_str_eff_ctrl IN NUMBER DEFAULT 1,
7464: p_parent_sort_order IN VARCHAR2
7465: )
7466: IS
7467: SELECT bev.comp_fixed_rev_code
7468: FROM bom_copy_explosions_v bev
7469: WHERE bev.sort_order = p_parent_sort_order;
7470: CURSOR l_eff_date_for_rev_csr (
7471: p_inventory_item_id IN NUMBER,
7472: p_organization_id IN NUMBER,
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
8020: AND bic.component_item_id = msi.inventory_item_id
8021: AND bic.component_item_id <> to_item_id
8022: AND NVL (bic.eco_for_production, 2) = 2
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
8389: AND bic.component_item_id = msi.inventory_item_id
8390: AND bic.component_item_id <> to_item_id
8391: AND NVL (bic.eco_for_production, 2) = 2
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
8791: AND bic.component_item_id = msi.inventory_item_id
8792: AND bic.component_item_id <> to_item_id
8793: AND NVL (bic.eco_for_production, 2) = 2
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
9190: AND bic.component_item_id = msi.inventory_item_id
9191: AND bic.component_item_id <> to_item_id
9192: AND NVL (bic.eco_for_production, 2) = 2
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
9590: AND bic.component_item_id = msi.inventory_item_id
9591: AND bic.component_item_id <> to_item_id
9592: AND NVL (bic.eco_for_production, 2) = 2
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
9794: AND bcb.component_item_id <> to_item_id
9795: AND 'T' <>
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
9895: AND bcb.component_sequence_id = bev.component_sequence_id
9896: AND bev.bill_sequence_id = from_sequence_id
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
9923: AND bcb.component_item_id <> to_item_id
9924: AND 'T' <>
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
10024: AND bcb.component_sequence_id = bev.component_sequence_id
10025: AND bev.bill_sequence_id = from_sequence_id
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
10089: AND bcb.component_item_id <> to_item_id
10090: AND msib1.organization_id = to_org_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
10191: AND bcb.component_sequence_id = bev.component_sequence_id
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
10290: AND bcb.component_item_id <> to_item_id
10291: AND bcb.implementation_date IS NOT NULL
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
10390: AND bcb.component_sequence_id = bev.component_sequence_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
10633: AND bcb.component_sequence_id = bev.component_sequence_id
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
11339: AND NVL (brd.acd_type, 1) <> 3
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
11429: AND NVL (bic.eco_for_production, 2) = 2
11430: AND bsc.component_sequence_id = bic.created_by
11431: AND NVL (bsc.acd_type, 1) <> 3
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
11579: AND bco.component_sequence_id = bic.created_by
11580: AND bos.routing_sequence_id = to_rtg_seq_id