DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on WMS_LABEL_FORMATS

Line 1893: from wms_label_set_formats wlfs , wms_label_formats wlf

1889: --R12 PROJECT LABEL SET with RFID
1890:
1891: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
1892: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
1893: from wms_label_set_formats wlfs , wms_label_formats wlf
1894: where WLFS.SET_ID = p_format_set_id
1895: and wlfs.set_id = wlf.label_format_id
1896: and wlf.label_entity_type = 1
1897: AND WLF.DOCUMENT_ID = 1

Line 1899: select label_format_id, nvl(wlf.label_entity_type,0) from wms_label_formats wlf

1895: and wlfs.set_id = wlf.label_format_id
1896: and wlf.label_entity_type = 1
1897: AND WLF.DOCUMENT_ID = 1
1898: UNION --FOR FORMAT
1899: select label_format_id, nvl(wlf.label_entity_type,0) from wms_label_formats wlf
1900: where wlf.label_format_id = p_format_set_id
1901: and nvl(wlf.label_entity_type,0) = 0--for label formats only validation
1902: AND WLF.DOCUMENT_ID = 1 ;
1903: