[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fm.formula_id, fm.formula_no, fm.formula_vers,fe.min_qty, fe.max_qty,
fe.std_qty, fe.detail_uom, fe.preference,fe.last_update_date,
DECODE(s.status_type,900,699,s.status_type)
FROM gmd_recipe_validity_rules fe, fm_form_mst fm, gmd_recipes_b r, fm_matl_dtl fdtl, gmd_status s
WHERE fe.inventory_item_id = V_item_id
AND fe.recipe_use = eff_type
AND fdtl.formula_id = fm.formula_id /* Added in Bug No.8639969 */
AND fdtl.line_type = 1 /* Added in Bug No.8639969 */
AND fdtl.inventory_item_id = fe.inventory_item_id /* Added in Bug No.8639969 */
AND fe.validity_rule_status = s.status_code
AND fe.validity_rule_status NOT IN (800,1000) /* Added in Bug No.8639969 */
AND fm.formula_status LIKE NVL(inact_status,'%')
AND TRUNC(fe.start_date) <= TRUNC(TO_DATE(eff_date,'DD-MM-RRRR'))
AND (TRUNC(fe.end_date) >= TRUNC(TO_DATE(eff_date,'DD-MM-RRRR'))
OR fe.end_date IS NULL)
AND fe.delete_mark = 0
AND r.formula_id = fm.formula_id
AND fe.recipe_id = r.recipe_id
AND fm.delete_mark = 0
AND (pvalidity_organization_type = 2
OR fe.organization_id IS NULL
OR (pvalidity_organization_type = 0 AND fe.organization_id = porganization_id )
OR (pvalidity_organization_type = 1 AND fe.organization_id IN ( SELECT organization_id
FROM org_access_view
WHERE responsibility_id = presp_id)))
-- Bug 4777885 KSHUKLA : Start
ORDER BY fe.orgn_code asc,10 desc, 8, fe.start_date desc;