DBA Data[Home] [Help]

APPS.INV_LABEL_PVT3 dependencies on WMS_LABEL_FORMATS

Line 454: from wms_label_set_formats wlfs , wms_label_formats wlf

450: --R12 PROJECT LABEL SET with RFID
451:
452: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
453: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
454: from wms_label_set_formats wlfs , wms_label_formats wlf
455: where WLFS.SET_ID = p_format_set_id
456: and wlfs.set_id = wlf.label_format_id
457: and wlf.label_entity_type = 1
458: AND WLF.DOCUMENT_ID = 3

Line 461: from wms_label_formats wlf

457: and wlf.label_entity_type = 1
458: AND WLF.DOCUMENT_ID = 3
459: UNION --FOR FORMATS
460: select label_format_id,nvl(wlf.label_entity_type,0)
461: from wms_label_formats wlf
462: where wlf.label_format_id = p_format_set_id
463: and nvl(wlf.label_entity_type,0) = 0--for label formats only validation
464: AND WLF.DOCUMENT_ID = 3 ;
465:

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

1204:
1205: /* Changed for R12 RFID project
1206: * while getting variables for format
1207: * Check whether EPC field is included in the format
1208: * If it is included, it will later query WMS_LABEL_FORMATS
1209: * table to get RFID related information
1210: * Otherwise, it does not need to do that
1211: */
1212: