[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:
428: BET.COMPONENT_ITEM_ID ASSEMBLY_ITEM_ID ,
429: ATDOCS.ATTACHED_DOCUMENT_ID ITEM_NUM ,
430: BET.COMP_BILL_SEQ_ID ,
431: BET.GROUP_ID ,
432: BOM_GLOBALS.GET_ALTERNATE(BET.BILL_SEQUENCE_ID) ALT_BOM_DESG,
433: BET.SORT_ORDER PARENT_SORT_ORDER,
434: BET.STRUCTURE_TYPE_ID STRUCTURE_TYPE_ID ,
435: TO_CHAR(ATDOCS.ATTACHED_DOCUMENT_ID) PK1_VALUE,
436: BET.HGRID_FLAG HGRID_FLAG ,
4538: CURSOR c1 IS
4539: SELECT revision, revision_id,revision_label FROM mtl_item_revisions_b WHERE
4540: inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND
4541: effectivity_date <= p_effectivity_date
4542: 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
4543: ORDER BY effectivity_date DESC;
4544:
4545: BEGIN
4546: