APPS.WMS_CARTNZN_PUB dependencies on WMS_SELECTION_CRITERIA_TXN

Line 3592: FROM wms_selection_criteria_txn_v

3588: END IF;
3589:
3590: SELECT count(1)
3591: INTO l_rulebased_setup_exists
3592: FROM wms_selection_criteria_txn_v
3593: WHERE rule_type_code = 12
3594: AND enabled_flag = 1
3595: AND from_organization_id = p_org_id
3596: AND ROWNUM = 1;

Line 6717: TYPE rules_table_type IS TABLE OF wms_selection_criteria_txn%rowtype;

6713: l_temp_id number;
6714: l_item_id number;
6715: l_packaging_return_status VARCHAR2(1);
6716:
6717: TYPE rules_table_type IS TABLE OF wms_selection_criteria_txn%rowtype;
6718: rules_table rules_table_type;
6719:
6720: CURSOR wct_rows IS
6721: SELECT wct.* FROM wms_cartonization_temp wct,

Line 6893: FROM wms_selection_criteria_txn

6889: END IF;
6890:
6891: SELECT * BULK COLLECT
6892: INTO rules_table
6893: FROM wms_selection_criteria_txn
6894: WHERE rule_type_code = 12
6895: AND from_organization_id = p_org_id -- Bug : 6962305
6896: AND enabled_flag = 1
6897: ORDER BY sequence_number;