DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on WMS_LABEL_FORMATS

Line 1944: from wms_label_set_formats wlfs , wms_label_formats wlf

1940: --R12 PROJECT LABEL SET with RFID
1941:
1942: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
1943: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
1944: from wms_label_set_formats wlfs , wms_label_formats wlf
1945: where WLFS.SET_ID = p_format_set_id
1946: and wlfs.set_id = wlf.label_format_id
1947: and wlf.label_entity_type = 1
1948: AND WLF.DOCUMENT_ID = 1

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

1946: and wlfs.set_id = wlf.label_format_id
1947: and wlf.label_entity_type = 1
1948: AND WLF.DOCUMENT_ID = 1
1949: UNION --FOR FORMAT
1950: select label_format_id, nvl(wlf.label_entity_type,0) from wms_label_formats wlf
1951: where wlf.label_format_id = p_format_set_id
1952: and nvl(wlf.label_entity_type,0) = 0--for label formats only validation
1953: AND WLF.DOCUMENT_ID = 1 ;
1954: