DBA Data[Home] [Help]

APPS.PMI_PRODUCTION_SUM dependencies on FND_PROFILE

Line 273: and reason_code = fnd_profile.value('PMI$REASON_CODE');

269: SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1
270: where item_id = item_id_v
271: and lot_id = lot_id_v
272: and doc_type = 'GRDI'
273: and reason_code = fnd_profile.value('PMI$REASON_CODE');
274: begin
275: if (item_id_vi = PKG_VAR_ITEM_ID_V AND
276: LOT_ID_VI = PKG_VAR_LOT_ID_V) then
277: return PKG_VAR_QC_GRADE_V;

Line 381: and reason_code = fnd_profile.value('PMI$REASON_CODE_BTCH_ADJ');

377: into ADJUST_BATCH_V
378: from ic_tran_cmp_vw1
379: where doc_id = BATCH_ID_VI
380: and doc_type = 'PROD'
381: and reason_code = fnd_profile.value('PMI$REASON_CODE_BTCH_ADJ');
382:
383: PKG_VAR_BATCH_ID_V3 := BATCH_ID_vi;
384: PKG_VAR_ADJUST_BATCH_V := ADJUST_BATCH_v;
385: