DBA Data[Home] [Help]

APPS.CSP_PLANNING_PARAMETERS_PVT dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 979: From csp_inv_loc_assignments cila,

975: END DELETE_PLANNING_PARAMETERS;
976: FUNCTION VALIDATE_CONDITION_TYPE(p_org_id NUMBER,p_subinv VARCHAR2) RETURN VARCHAR2 IS
977: Cursor c_resource(p_org_id Number,p_subinv Varchar2) Is
978: Select csi.condition_type
979: From csp_inv_loc_assignments cila,
980: csp_sec_inventories csi
981: Where cila.organization_id = p_org_id
982: And cila.subinventory_code = p_subinv
983: --And nvl(cila.effective_date_end,sysdate) >= sysdate /* Forward port fix of 115.9 bug 4896449*/