DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on WMS_LABEL_FORMATS

Line 1084: from wms_label_set_formats wlfs , wms_label_formats wlf

1080:
1081: --R12 PROJECT LABEL SET with RFID
1082: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
1083: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
1084: from wms_label_set_formats wlfs , wms_label_formats wlf
1085: where WLFS.SET_ID = p_format_set_id
1086: and wlfs.set_id = wlf.label_format_id
1087: and wlf.label_entity_type = 1
1088: AND WLF.DOCUMENT_ID = 2

Line 1091: from wms_label_formats wlf

1087: and wlf.label_entity_type = 1
1088: AND WLF.DOCUMENT_ID = 2
1089: UNION --FOR FORMATS
1090: select label_format_id,nvl(wlf.label_entity_type,0)
1091: from wms_label_formats wlf
1092: where wlf.label_format_id = p_format_set_id
1093: and nvl(wlf.label_entity_type,0) = 0 --for label formats only validation
1094: AND WLF.DOCUMENT_ID = 2 ;
1095: