APPS.INV_LABEL_PVT3 dependencies on WMS_LABEL_FORMATS

Line 484: from wms_label_set_formats wlfs , wms_label_formats wlf

480: --R12 PROJECT LABEL SET with RFID
481:
482: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
483: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
484: from wms_label_set_formats wlfs , wms_label_formats wlf
485: where WLFS.SET_ID = p_format_set_id
486: and wlfs.set_id = wlf.label_format_id
487: and wlf.label_entity_type = 1
488: AND WLF.DOCUMENT_ID = 3

Line 491: from wms_label_formats wlf

487: and wlf.label_entity_type = 1
488: AND WLF.DOCUMENT_ID = 3
489: UNION --FOR FORMATS
490: select label_format_id,nvl(wlf.label_entity_type,0)
491: from wms_label_formats wlf
492: where wlf.label_format_id = p_format_set_id
493: and nvl(wlf.label_entity_type,0) = 0--for label formats only validation
494: AND WLF.DOCUMENT_ID = 3 ;
495:

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

1566:
1567: /* Changed for R12 RFID project
1568: * while getting variables for format
1569: * Check whether EPC field is included in the format
1570: * If it is included, it will later query WMS_LABEL_FORMATS
1571: * table to get RFID related information
1572: * Otherwise, it does not need to do that
1573: */
1574: