DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on WMS_LABEL_FORMATS

Line 1050: from wms_label_set_formats wlfs , wms_label_formats wlf

1046: --R12 PROJECT LABEL SET with RFID
1047:
1048: CURSOR c_label_formats_in_set(p_format_set_id IN NUMBER) IS
1049: select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
1050: from wms_label_set_formats wlfs , wms_label_formats wlf
1051: where WLFS.SET_ID = p_format_set_id
1052: and wlfs.set_id = wlf.label_format_id
1053: and wlf.label_entity_type = 1
1054: AND WLF.DOCUMENT_ID = 4

Line 1057: from wms_label_formats wlf

1053: and wlf.label_entity_type = 1
1054: AND WLF.DOCUMENT_ID = 4
1055: UNION --FOR FORMATS
1056: select label_format_id,nvl(wlf.label_entity_type,0)
1057: from wms_label_formats wlf
1058: where wlf.label_format_id = p_format_set_id
1059: and nvl(wlf.label_entity_type,0) = 0--for label formats only validation
1060: AND WLF.DOCUMENT_ID = 4 ;
1061:

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

2422:
2423: /* Changed for R12 RFID project
2424: * while getting variables for format
2425: * Check whether EPC field is included in the format
2426: * If it is included, it will later query WMS_LABEL_FORMATS
2427: * table to get RFID related information
2428: * Otherwise, it does not need to do that
2429: */
2430: