DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on WMS_LABEL_FORMATS

Line 1077: from wms_label_set_formats wlfs , wms_label_formats wlf

1073:
1074: --R12 PROJECT LABEL SET with RFID
1075: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
1076: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
1077: from wms_label_set_formats wlfs , wms_label_formats wlf
1078: where WLFS.SET_ID = p_format_set_id
1079: and wlfs.set_id = wlf.label_format_id
1080: and wlf.label_entity_type = 1
1081: AND WLF.DOCUMENT_ID = 2

Line 1084: from wms_label_formats wlf

1080: and wlf.label_entity_type = 1
1081: AND WLF.DOCUMENT_ID = 2
1082: UNION --FOR FORMATS
1083: select label_format_id,nvl(wlf.label_entity_type,0)
1084: from wms_label_formats wlf
1085: where wlf.label_format_id = p_format_set_id
1086: and nvl(wlf.label_entity_type,0) = 0 --for label formats only validation
1087: AND WLF.DOCUMENT_ID = 2 ;
1088: