DBA Data[Home] [Help]

APPS.MTL_PARAMETERS_PKG dependencies on WMS_SELECTION_CRITERIA_TXN

Line 1950: FROM wms_selection_criteria_txn

1946: SELECT 'Y'
1947: INTO strgy_assn_exist
1948: FROM DUAL
1949: WHERE EXISTS(SELECT from_organization_id
1950: FROM wms_selection_criteria_txn
1951: WHERE from_organization_id = p_organization_id
1952: AND return_type_code = 'S'
1953: AND return_type_id = 8
1954: AND rule_type_code = 2);

Line 1964: SELECT wms_selection_criteria_txn_s.NEXTVAL

1960: IF strgy_assn_exist = 'Y' THEN
1961: RETURN;
1962: END IF;
1963:
1964: SELECT wms_selection_criteria_txn_s.NEXTVAL
1965: INTO l_stg_assignment_id
1966: FROM DUAL;
1967:
1968: wms_strategy_upgrade_pvt.insert_row(