APPS.WMS_POSTALLOC_PVT dependencies on WMS_SELECTION_CRITERIA_TXN

Line 2066: TYPE rules_table_type IS TABLE OF wms_selection_criteria_txn%ROWTYPE;

2062:
2063: l_api_return_status VARCHAR2(1);
2064: l_move_order_type NUMBER;
2065:
2066: TYPE rules_table_type IS TABLE OF wms_selection_criteria_txn%ROWTYPE;
2067: rules_table rules_table_type;
2068: rules_table1 rules_table_type;
2069:
2070: l_count NUMBER;

Line 2114: FROM wms_selection_criteria_txn

2110: END IF;
2111:
2112: SELECT * BULK COLLECT
2113: INTO rules_table1
2114: FROM wms_selection_criteria_txn
2115: WHERE rule_type_code = 12
2116: AND from_organization_id = p_org_id
2117: AND enabled_flag = 1
2118: ORDER BY sequence_number;

Line 2160: FROM wms_selection_criteria_txn

2156: END IF;
2157:
2158: SELECT * BULK COLLECT
2159: INTO rules_table
2160: FROM wms_selection_criteria_txn
2161: WHERE rule_type_code = 12
2162: AND from_organization_id = p_org_id
2163: AND enabled_flag = 1
2164: ORDER BY sequence_number;

Line 2580: FROM wms_selection_criteria_txn_v

2576:
2577: -- Rule Based Cartonization
2578: SELECT count(1)
2579: INTO l_rulebased_setup_exists
2580: FROM wms_selection_criteria_txn_v
2581: WHERE rule_type_code = 12
2582: AND enabled_flag = 1
2583: AND from_organization_id = p_org_id
2584: AND ROWNUM = 1;