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.RCV_HXT_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 33: , po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE

29: , po_number PO_HEADERS_ALL.segment1%TYPE
30: , po_header_id PO_HEADERS_ALL.po_header_id%TYPE
31: , po_line PO_LINES_ALL.line_num%TYPE
32: , po_line_id PO_LINES_ALL.po_line_id%TYPE
33: , po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
34: , po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
35: , project_id PO_DISTRIBUTIONS_ALL.project_id%TYPE
36: , task_id PO_DISTRIBUTIONS_ALL.task_id%TYPE
37: , po_price_type PO_TEMP_LABOR_RATES_V.asg_rate_type%TYPE

Line 108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE

104: , order_type_lookup_code PO_LINES_ALL.order_type_lookup_code%TYPE
105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE

Line 109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE

105: , start_date PO_LINES_ALL.start_date%TYPE
106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE

Line 110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE

106: , expiration_date PO_LINES_ALL.expiration_date%TYPE
107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE

Line 111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE

107: , job_id PO_LINES_ALL.job_id%TYPE
108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
115: , ship_to_organization_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE

Line 112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE

108: , line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE
109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
115: , ship_to_organization_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE
116: , ship_to_location_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE

Line 113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE

109: , approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE
110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
115: , ship_to_organization_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE
116: , ship_to_location_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE
117: , time_attribute_id HXC_TIME_ATTRIBUTES.time_attribute_id%TYPE

Line 114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE

110: , cancel_flag PO_LINE_LOCATIONS_ALL.cancel_flag%TYPE
111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
115: , ship_to_organization_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE
116: , ship_to_location_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE
117: , time_attribute_id HXC_TIME_ATTRIBUTES.time_attribute_id%TYPE
118: );

Line 115: , ship_to_organization_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE

111: , closed_code PO_LINE_LOCATIONS_ALL.closed_code%TYPE
112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
115: , ship_to_organization_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE
116: , ship_to_location_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE
117: , time_attribute_id HXC_TIME_ATTRIBUTES.time_attribute_id%TYPE
118: );
119:

Line 116: , ship_to_location_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE

112: , qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE
113: , tolerable_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
114: , timecard_amount PO_LINE_LOCATIONS_ALL.amount%TYPE
115: , ship_to_organization_id PO_LINE_LOCATIONS_ALL.ship_to_organization_id%TYPE
116: , ship_to_location_id PO_LINE_LOCATIONS_ALL.ship_to_location_id%TYPE
117: , time_attribute_id HXC_TIME_ATTRIBUTES.time_attribute_id%TYPE
118: );
119:
120: TYPE po_distribution_cr IS RECORD

Line 666: , po_line_locations_all poll

662: , g_po_line_cache(p_po_line_id).timecard_amount
663: , g_po_line_cache(p_po_line_id).ship_to_organization_id
664: , g_po_line_cache(p_po_line_id).ship_to_location_id
665: FROM po_lines_all pol
666: , po_line_locations_all poll
667: WHERE pol.po_line_id = p_po_line_id
668: AND poll.po_line_id = pol.po_line_id;
669: END IF;
670:

Line 1789: l_qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE;

1785: l_return_status VARCHAR2(1);
1786: l_po_line_id BINARY_INTEGER;
1787: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;
1788: l_tolerable_amount PO_LINES_ALL.amount%TYPE;
1789: l_qty_rcv_exception_code PO_LINE_LOCATIONS_ALL.qty_rcv_exception_code%TYPE;
1790:
1791: GET_TIMECARD_AMOUNT_FAILED EXCEPTION;
1792: l_api_name CONSTANT varchar2(30) := 'Validate_Amount_Tolerances';
1793: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;