APPS.WMS_RULE_PVT dependencies on WMS_LABEL_FORMATS

Line 17272: l_label_format_name wms_label_formats.label_format_name%TYPE;

17268: l_count NUMBER;
17269: l_return_status NUMBER;
17270: l_label_format_id NUMBER;
17271: l_document_id NUMBER;
17272: l_label_format_name wms_label_formats.label_format_name%TYPE;
17273: l_api_version CONSTANT NUMBER := 1.0;
17274: l_api_name CONSTANT VARCHAR2(30) := 'ApplyLabel';
17275: l_msg_data VARCHAR2(2000);
17276: l_strategy_id NUMBER := NULL;

Line 17290: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr

17286: , rules.rule_weight
17287: , rules.type_hdr_id
17288: , wl.label_format_name
17289: , wl.document_id
17290: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
17291: WHERE rules.type_code = 4
17292: AND rules.type_hdr_id = wl.label_format_id
17293: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
17294: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug #3452076

Line 17306: FROM wms_label_formats

17302:
17303: CURSOR l_default_label_curs IS
17304: SELECT label_format_id
17305: , label_format_name
17306: FROM wms_label_formats
17307: WHERE document_id = l_document_id
17308: AND default_format_flag IN ('Y', 'y');
17309:
17310: CURSOR l_label_requests_curs IS

Line 17323: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr

17319: BEGIN
17320: SAVEPOINT assignlabelsp;
17321: ----
17322: SELECT count(rules.rule_id ) into ll_ctr
17323: FROM wms_rules_b rules, wms_label_formats wl, wms_label_requests wlr
17324: WHERE rules.type_code = 4
17325: AND rules.type_hdr_id = wl.label_format_id
17326: AND wl.label_format_id = NVL(wlr.label_format_id, wl.label_format_id)
17327: AND NVL(format_disable_date, SYSDATE + 1) > SYSDATE --Bug # 3452076