804: end if;
805:
806: select organization_id, primary_item_id
807: into l_org_id, l_item_id
808: from wip_discrete_jobs
809: where wip_entity_id = p_wip_entity_id;
810:
811: INV_LABEL.PRINT_LABEL_MANUAL_WRAP (
812: P_BUSINESS_FLOW_CODE => NULL,
990: INTO l_lot_number,
991: l_sch_st_date,
992: l_item_rev
993: FROM mtl_system_items msi,
994: wip_discrete_jobs wdj
995: WHERE wdj.wip_entity_id = l_wip_entity_id
996: AND msi.organization_id = wdj.organization_id
997: AND msi.inventory_item_id = wdj.primary_item_id;
998: -- End : Changes to fix bug #6860138 --