eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CBC_PO_GRP dependencies on PO_REQUISITION_HEADERS

Line 470: l_max_cbc_acc_date po_requisition_headers.cbc_accounting_date%TYPE;

466: l_po_prd_sts VARCHAR2(1);
467: l_prev_cbc_acct_date DATE;
468: l_max_gl_date po_distributions.gl_encumbered_date%TYPE;
469: l_min_gl_date po_distributions.gl_encumbered_date%TYPE;
470: l_max_cbc_acc_date po_requisition_headers.cbc_accounting_date%TYPE;
471: l_min_cbc_acc_date po_requisition_headers.cbc_accounting_date%TYPE;
472: l_po_cbc_acct_date DATE;
473:
474: -- Added for PRC.FP.J, 3173178

Line 471: l_min_cbc_acc_date po_requisition_headers.cbc_accounting_date%TYPE;

467: l_prev_cbc_acct_date DATE;
468: l_max_gl_date po_distributions.gl_encumbered_date%TYPE;
469: l_min_gl_date po_distributions.gl_encumbered_date%TYPE;
470: l_max_cbc_acc_date po_requisition_headers.cbc_accounting_date%TYPE;
471: l_min_cbc_acc_date po_requisition_headers.cbc_accounting_date%TYPE;
472: l_po_cbc_acct_date DATE;
473:
474: -- Added for PRC.FP.J, 3173178
475: l_max_bpa_fiscal_year NUMBER;

Line 667: FROM po_requisition_headers

663: ELSIF (p_document_type LIKE 'REQ%') THEN
664:
665: SELECT cbc_accounting_date
666: INTO l_prev_cbc_acct_date
667: FROM po_requisition_headers
668: WHERE requisition_header_id = p_document_id;
669:
670: END IF;
671:

Line 790: FROM po_requisition_headers prh,

786: SELECT max(prh.cbc_accounting_date),
787: min(prh.cbc_accounting_date)
788: INTO l_max_cbc_acc_date,
789: l_min_cbc_acc_date
790: FROM po_requisition_headers prh,
791: po_requisition_lines prl,
792: po_line_locations poll
793: WHERE poll.po_header_id = p_document_id
794: AND poll.line_location_id = prl.line_location_id

Line 809: FROM po_requisition_headers prh,

805: SELECT max(prh.cbc_accounting_date),
806: min(prh.cbc_accounting_date)
807: INTO l_max_cbc_acc_date,
808: l_min_cbc_acc_date
809: FROM po_requisition_headers prh,
810: po_requisition_lines prl,
811: po_line_locations poll
812: WHERE poll.po_release_id = p_document_id
813: AND prl.line_location_id = poll.line_location_id

Line 1031: FROM po_requisition_headers

1027:
1028: -- Cursor to get accounting date FROM PO_Req headers for this document
1029: Cursor c_get_req_date IS
1030: SELECT cbc_accounting_date
1031: FROM po_requisition_headers
1032: WHERE requisition_header_id = p_document_id ;
1033:
1034: -- Cursor to get accounting date FROM PO_Rel headers for this document
1035: Cursor c_get_rel_date IS

Line 1057: -- FROM po_requisition_headers r,

1053: -- Cursor to get the latest accounting date FROM requisitions relating to the PO
1054: -- Bug 2885953 - amended cursor below for performance enhancements
1055: -- Cursor c_max_req_date IS
1056: -- SELECT max(r.cbc_accounting_date)
1057: -- FROM po_requisition_headers r,
1058: -- po_distributions_v p
1059: -- WHERE r.requisition_header_id = p.requisition_header_id
1060: -- AND p.po_header_id = p_document_id;
1061: Cursor c_max_req_date IS

Line 1063: FROM po_requisition_headers porh,

1059: -- WHERE r.requisition_header_id = p.requisition_header_id
1060: -- AND p.po_header_id = p_document_id;
1061: Cursor c_max_req_date IS
1062: SELECT max(porh.cbc_accounting_date)
1063: FROM po_requisition_headers porh,
1064: po_distributions pod,
1065: po_requisition_lines porl,
1066: po_req_distributions pord
1067: WHERE pod.po_header_id = p_document_id

Line 1077: -- FROM po_requisition_headers r,

1073: -- Cursor to get the latest accounting date FROM requisitons relating to the Release
1074: -- Bug 2885953 - amended cursor below for performance enhancements
1075: -- Cursor c_max_rel_req_date IS
1076: -- SELECT max(r.cbc_accounting_date)
1077: -- FROM po_requisition_headers r,
1078: -- po_distributions_v p
1079: -- WHERE r.requisition_header_id = p.requisition_header_id
1080: -- AND p.po_release_id = p_document_id;
1081: Cursor c_max_rel_req_date IS

Line 1083: FROM po_requisition_headers porh,

1079: -- WHERE r.requisition_header_id = p.requisition_header_id
1080: -- AND p.po_release_id = p_document_id;
1081: Cursor c_max_rel_req_date IS
1082: SELECT max(porh.cbc_accounting_date)
1083: FROM po_requisition_headers porh,
1084: po_distributions pod,
1085: po_requisition_lines porl,
1086: po_req_distributions pord
1087: WHERE pod.po_release_id = p_document_id

Line 1558: UPDATE po_requisition_headers

1554: ELSIF (p_document_type LIKE 'REQ%')
1555: THEN
1556: -- Bug 2885953 added if statement and removed nvl from update for performance enhancement
1557: IF p_cbc_acct_date IS NOT NULL THEN
1558: UPDATE po_requisition_headers
1559: -- SET cbc_accounting_date = NVL(p_cbc_acct_date, cbc_accounting_date)
1560: SET cbc_accounting_date = p_cbc_acct_date
1561: WHERE requisition_header_id = p_document_id ;
1562:

Line 1679: po_requisition_headers porh,

1675: pod.set_of_books_id sob_id,
1676: r.cbc_accounting_date rel_acct_date
1677: From po_distributions pod,
1678: po_releases r,
1679: po_requisition_headers porh,
1680: po_requisition_lines porl,
1681: po_req_distributions pord
1682: Where pod.po_release_id = p_document_id
1683: And pod.line_location_id = nvl(p_line_location_id, pod.line_location_id)