APPS.WIP_VALIDATE dependencies on MFG_LOOKUPS

Line 606: FROM mfg_lookups

602: END IF;
603:
604: SELECT 'VALID'
605: INTO l_dummy
606: FROM mfg_lookups
607: WHERE lookup_type = 'WIP_ENTITY'
608: AND lookup_code = p_entity_type;
609:
610: RETURN TRUE;

Line 2267: FROM mfg_lookups

2263: END IF;
2264:
2265: SELECT 'VALID'
2266: INTO l_dummy
2267: FROM mfg_lookups
2268: WHERE lookup_type = 'SYS_YES_NO'
2269: AND lookup_code = p_firm_planned_flag;
2270:
2271: RETURN TRUE;

Line 2312: FROM mfg_lookups

2308: END IF;
2309:
2310: SELECT 'VALID'
2311: INTO l_dummy
2312: FROM mfg_lookups
2313: WHERE lookup_type = 'WIP_DISCRETE_JOB'
2314: AND lookup_code = p_job_type;
2315:
2316: RETURN TRUE;

Line 2447: FROM mfg_lookups

2443: END IF;
2444:
2445: SELECT 'VALID'
2446: INTO l_dummy
2447: FROM mfg_lookups
2448: WHERE lookup_type = 'WIP_JOB_STATUS'
2449: AND lookup_code = p_status_type;
2450:
2451: RETURN TRUE;

Line 2492: FROM mfg_lookups

2488: END IF;
2489:
2490: SELECT 'VALID'
2491: INTO l_dummy
2492: FROM mfg_lookups
2493: WHERE lookup_type = 'WIP_SUPPLY'
2494: AND lookup_code = p_wip_supply_type;
2495:
2496: RETURN TRUE;

Line 6836: FROM MFG_LOOKUPS

6832: END IF;
6833:
6834: SELECT 'VALID'
6835: INTO l_dummy
6836: FROM MFG_LOOKUPS
6837: WHERE lookup_type = 'BOM_AUTOCHARGE_TYPE'
6838: AND lookup_code = p_autocharge_type;
6839:
6840: RETURN TRUE;

Line 6885: FROM MFG_LOOKUPS

6881: END IF;
6882:
6883: SELECT 'VALID'
6884: INTO l_dummy
6885: FROM MFG_LOOKUPS
6886: WHERE lookup_type = 'CST_BASIS'
6887: AND lookup_code = p_basis_type;
6888:
6889: RETURN TRUE;

Line 7766: FROM MFG_LOOKUPS

7762: END IF;
7763:
7764: SELECT 'VALID'
7765: INTO l_dummy
7766: FROM MFG_LOOKUPS
7767: WHERE lookup_type = p_lookup_type
7768: AND lookup_code = p_process_phase;
7769:
7770: RETURN TRUE;

Line 7815: FROM MFG_LOOKUPS

7811: END IF;
7812:
7813: SELECT 'VALID'
7814: INTO l_dummy
7815: FROM MFG_LOOKUPS
7816: WHERE lookup_type = 'WIP_PROCESS_STATUS'
7817: AND lookup_code = p_process_status;
7818:
7819: RETURN TRUE;

Line 8270: FROM MFG_LOOKUPS

8266: END IF;
8267:
8268: SELECT 'VALID'
8269: INTO l_dummy
8270: FROM MFG_LOOKUPS
8271: WHERE lookup_type = 'BOM_RESOURCE_TYPE'
8272: AND lookup_code = p_resource_type;
8273:
8274: RETURN TRUE;

Line 8319: FROM MFG_LOOKUPS

8315: END IF;
8316:
8317: SELECT 'VALID'
8318: INTO l_dummy
8319: FROM MFG_LOOKUPS
8320: WHERE lookup_type = 'SYS_YES_NO'
8321: AND lookup_code = p_standard_rate_flag;
8322:
8323: RETURN TRUE;

Line 8614: FROM mfg_lookups ml

8610: END IF;
8611:
8612: SELECT 'VALID'
8613: INTO l_dummy
8614: FROM mfg_lookups ml
8615: WHERE ml.lookup_code = p_intraop_step_type
8616: AND ml.lookup_type = 'WIP_INTRAOPERATION_STEP';
8617:
8618: RETURN TRUE;

Line 9059: FROM mfg_lookups ml

9055: END IF;
9056:
9057: SELECT 'VALID'
9058: INTO l_dummy
9059: FROM mfg_lookups ml
9060: WHERE ml.lookup_code = p_to_intraop_step_type
9061: AND ml.lookup_type = 'WIP_INTRAOPERATION_STEP';
9062:
9063: RETURN TRUE;

Line 9254: FROM mfg_lookups ml

9250: END IF;
9251:
9252: SELECT 'VALID'
9253: INTO l_dummy
9254: FROM mfg_lookups ml
9255: WHERE ml.lookup_code = p_transaction_type_id
9256: AND ml.lookup_type = p_lookup_type;
9257:
9258: RETURN TRUE;