APPS.WMS_CARTNZN_PUB dependencies on WMS_SELECTION_CRITERIA_TXN

Line 3574: FROM wms_selection_criteria_txn_v

3570: END IF;
3571:
3572: SELECT count(1)
3573: INTO l_rulebased_setup_exists
3574: FROM wms_selection_criteria_txn_v
3575: WHERE rule_type_code = 12
3576: AND enabled_flag = 1
3577: AND from_organization_id = p_org_id
3578: AND ROWNUM = 1;

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

6772: l_temp_id number;
6773: l_item_id number;
6774: l_packaging_return_status VARCHAR2(1);
6775:
6776: TYPE rules_table_type IS TABLE OF wms_selection_criteria_txn%rowtype;
6777: rules_table rules_table_type;
6778:
6779: CURSOR wct_rows IS
6780: SELECT wct.* FROM wms_cartonization_temp wct,

Line 6956: FROM wms_selection_criteria_txn

6952: END IF;
6953:
6954: SELECT * BULK COLLECT
6955: INTO rules_table
6956: FROM wms_selection_criteria_txn
6957: WHERE rule_type_code = 12
6958: AND from_organization_id = p_org_id -- Bug : 6962305
6959: AND enabled_flag = 1
6960: ORDER BY sequence_number;