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.PO_RELGEN_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 863: l_quantity po_requisition_lines_all.quantity%TYPE := null;

859: --frkhan 1/12/99
860: x_country_of_origin_code varchar2(2);
861:
862: /* */
863: l_quantity po_requisition_lines_all.quantity%TYPE := null;
864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;

Line 867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;

863: l_quantity po_requisition_lines_all.quantity%TYPE := null;
864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
868: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
869: /* */
870:
871: --

Line 868: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;

864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
868: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
869: /* */
870:
871: --
872: l_promised_date DATE := NULL;

Line 3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,

3618: For each of the above
3619: Local ASL will be preferred over global asl
3620: Valid Vendor site will be preferred than vendor_site being null
3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )

Line 3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,

3619: Local ASL will be preferred over global asl
3620: Valid Vendor site will be preferred than vendor_site being null
3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number

Line 3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,

3620: Valid Vendor site will be preferred than vendor_site being null
3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number
3628: as