DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on WMS_LABEL_FORMATS

Line 1277: from wms_label_set_formats wlfs , wms_label_formats wlf

1273: --R12 PROJECT LABEL SET with RFID
1274:
1275: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
1276: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
1277: from wms_label_set_formats wlfs , wms_label_formats wlf
1278: where WLFS.SET_ID = p_format_set_id
1279: and wlfs.set_id = wlf.label_format_id
1280: and wlf.label_entity_type = 1
1281: AND WLF.DOCUMENT_ID = 4

Line 1284: from wms_label_formats wlf

1280: and wlf.label_entity_type = 1
1281: AND WLF.DOCUMENT_ID = 4
1282: UNION --FOR FORMATS
1283: select label_format_id,nvl(wlf.label_entity_type,0)
1284: from wms_label_formats wlf
1285: where wlf.label_format_id = p_format_set_id
1286: and nvl(wlf.label_entity_type,0) = 0--for label formats only validation
1287: AND WLF.DOCUMENT_ID = 4 ;
1288:

Line 3207: * If it is included, it will later query WMS_LABEL_FORMATS

3203:
3204: /* Changed for R12 RFID project
3205: * while getting variables for format
3206: * Check whether EPC field is included in the format
3207: * If it is included, it will later query WMS_LABEL_FORMATS
3208: * table to get RFID related information
3209: * Otherwise, it does not need to do that
3210: */
3211: