APPS.GMF_SUBLEDGER_REPORT dependencies on IC_TRAN_PND

Line 409: CURSOR c_ic_tran_pnd(v_doc_type VARCHAR2,

405: AND sb.sub_event_code = v_sub_event_code;
406:
407: c_recv_hst c_po_recv_hst%ROWTYPE;
408:
409: CURSOR c_ic_tran_pnd(v_doc_type VARCHAR2,
410: v_doc_id NUMBER, v_line_id NUMBER) IS
411: SELECT
412: reason_code
413: FROM

Line 414: ic_tran_pnd

410: v_doc_id NUMBER, v_line_id NUMBER) IS
411: SELECT
412: reason_code
413: FROM
414: ic_tran_pnd
415: WHERE
416: doc_type = v_doc_type
417: AND doc_id = v_doc_id
418: AND line_id = v_line_id

Line 428: c_ic_tran c_ic_tran_pnd%ROWTYPE;

424: WHERE
425: doc_type = v_doc_type
426: AND doc_id = v_doc_id
427: AND line_id = v_line_id;
428: c_ic_tran c_ic_tran_pnd%ROWTYPE;
429:
430: --Begin Bug#3072197
431: --To retrieve Reason code for Invetory Transfers (XFER).
432: CURSOR c_ic_xfer_tran(v_trans_id NUMBER) IS

Line 436: ic_tran_pnd

432: CURSOR c_ic_xfer_tran(v_trans_id NUMBER) IS
433: SELECT
434: reason_code
435: FROM
436: ic_tran_pnd
437: WHERE
438: trans_id = v_trans_id;
439: --End Bug#3072197
440:

Line 448: ic_tran_pnd t,

444: d.original_qty, -- Bug# 3772552 - Fwd port for 3544905
445: t.whse_code,
446: t.trans_um
447: FROM
448: ic_tran_pnd t,
449: gme_material_details d
450: WHERE
451: t.doc_type = 'PROD'
452: AND t.line_id = v_line_id

Line 892: OPEN c_ic_tran_pnd(r.doc_type, r.doc_id, r.line_id);

888: END IF;
889: CLOSE c_ic_xfer_tran;
890: ELSE
891: --End Bug#3072197
892: OPEN c_ic_tran_pnd(r.doc_type, r.doc_id, r.line_id);
893: FETCH c_ic_tran_pnd INTO c_ic_tran;
894: IF ( c_ic_tran_pnd%NOTFOUND ) THEN
895: c_ic_tran.reason_code := NULL;
896: END IF;

Line 893: FETCH c_ic_tran_pnd INTO c_ic_tran;

889: CLOSE c_ic_xfer_tran;
890: ELSE
891: --End Bug#3072197
892: OPEN c_ic_tran_pnd(r.doc_type, r.doc_id, r.line_id);
893: FETCH c_ic_tran_pnd INTO c_ic_tran;
894: IF ( c_ic_tran_pnd%NOTFOUND ) THEN
895: c_ic_tran.reason_code := NULL;
896: END IF;
897: CLOSE c_ic_tran_pnd;

Line 894: IF ( c_ic_tran_pnd%NOTFOUND ) THEN

890: ELSE
891: --End Bug#3072197
892: OPEN c_ic_tran_pnd(r.doc_type, r.doc_id, r.line_id);
893: FETCH c_ic_tran_pnd INTO c_ic_tran;
894: IF ( c_ic_tran_pnd%NOTFOUND ) THEN
895: c_ic_tran.reason_code := NULL;
896: END IF;
897: CLOSE c_ic_tran_pnd;
898: --Begin Bug#3072197

Line 897: CLOSE c_ic_tran_pnd;

893: FETCH c_ic_tran_pnd INTO c_ic_tran;
894: IF ( c_ic_tran_pnd%NOTFOUND ) THEN
895: c_ic_tran.reason_code := NULL;
896: END IF;
897: CLOSE c_ic_tran_pnd;
898: --Begin Bug#3072197
899: END IF;
900: --End Bug#3072197
901: /* Begin Bug#2365391 - Nayini Vikranth */