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.POS_ACK_SEARCH dependencies on FND_DATE

Line 1771: and ( acceptance_required_by >= decode(l_Start_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_Start_Date)) or (acceptance_required_by is null and l_Start_Date is null) )

1767: where
1768: acceptance_status = nvl(l_acceptance_status, acceptance_status)
1769: and acceptance_required = nvl(l_Acceptance_Reqd_Flag, acceptance_required)
1770: -- and acceptance_required_by between nvl(l_Start_Date, acceptance_required_by) and nvl(l_End_Date, acceptance_required_by)
1771: and ( acceptance_required_by >= decode(l_Start_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_Start_Date)) or (acceptance_required_by is null and l_Start_Date is null) )
1772: and (acceptance_required_by <= decode(l_End_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_End_Date)) or (acceptance_required_by is null and l_End_Date is null) )
1773: and po_number like nvl(l_PO_Number, po_number)
1774: and supplier_site_id = nvl(l_Supplier_Site_Id, supplier_site_id)
1775: and document_type_code = nvl(l_Document_Type_Code, document_type_code) order by po_number;

Line 1772: and (acceptance_required_by <= decode(l_End_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_End_Date)) or (acceptance_required_by is null and l_End_Date is null) )

1768: acceptance_status = nvl(l_acceptance_status, acceptance_status)
1769: and acceptance_required = nvl(l_Acceptance_Reqd_Flag, acceptance_required)
1770: -- and acceptance_required_by between nvl(l_Start_Date, acceptance_required_by) and nvl(l_End_Date, acceptance_required_by)
1771: and ( acceptance_required_by >= decode(l_Start_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_Start_Date)) or (acceptance_required_by is null and l_Start_Date is null) )
1772: and (acceptance_required_by <= decode(l_End_Date, null, acceptance_required_by, fnd_date.chardate_to_date(l_End_Date)) or (acceptance_required_by is null and l_End_Date is null) )
1773: and po_number like nvl(l_PO_Number, po_number)
1774: and supplier_site_id = nvl(l_Supplier_Site_Id, supplier_site_id)
1775: and document_type_code = nvl(l_Document_Type_Code, document_type_code) order by po_number;
1776: l_po_rec l_cursor%ROWTYPE;

Line 1800: fnd_date.initialize(l_format_mask);

1796: into l_format_mask
1797: from icx_sessions
1798: where session_id = l_session_id;
1799:
1800: fnd_date.initialize(l_format_mask);
1801:
1802: open l_cursor;
1803: LOOP
1804: fetch l_cursor into l_po_rec;