[Home] [Help]
177: CURSOR c1 IS
178: SELECT revision, revision_id,revision_label FROM mtl_item_revisions_b WHERE
179: inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND
180: effectivity_date <= p_effectivity_date
181: AND ((BOM_GLOBALS.get_show_Impl_comps_only = 'Y' AND implementation_date IS NOT NULL) OR BOM_GLOBALS.get_show_Impl_comps_only = 'N') -- added for Bug 7242865
182: ORDER BY effectivity_date DESC;
183:
184: BEGIN
185:
440: BET.COMPONENT_ITEM_ID ASSEMBLY_ITEM_ID ,
441: ATDOCS.ATTACHED_DOCUMENT_ID ITEM_NUM ,
442: BET.COMP_BILL_SEQ_ID ,
443: BET.GROUP_ID ,
444: BOM_GLOBALS.GET_ALTERNATE(BET.BILL_SEQUENCE_ID) ALT_BOM_DESG,
445: BET.SORT_ORDER PARENT_SORT_ORDER,
446: BET.STRUCTURE_TYPE_ID STRUCTURE_TYPE_ID ,
447: TO_CHAR(ATDOCS.ATTACHED_DOCUMENT_ID) PK1_VALUE,
448: BET.HGRID_FLAG HGRID_FLAG ,
4698: CURSOR c1 IS
4699: SELECT revision, revision_id,revision_label FROM mtl_item_revisions_b WHERE
4700: inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND
4701: effectivity_date <= p_effectivity_date
4702: AND ((BOM_GLOBALS.get_show_Impl_comps_only = 'Y' AND implementation_date IS NOT NULL) OR BOM_GLOBALS.get_show_Impl_comps_only = 'N') -- added for Bug 7242865
4703: ORDER BY effectivity_date DESC;
4704:
4705: BEGIN
4706: