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_HEADERS

Line 29: , po_number PO_HEADERS_ALL.segment1%TYPE

25: , detail_deleted VARCHAR2(30)
26: , detail_date_from HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
27: , detail_date_to HXC_TIME_BUILDING_BLOCKS.date_to%TYPE
28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_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

Line 30: , po_header_id PO_HEADERS_ALL.po_header_id%TYPE

26: , detail_date_from HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
27: , detail_date_to HXC_TIME_BUILDING_BLOCKS.date_to%TYPE
28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_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

Line 59: , org_id PO_HEADERS_ALL.org_id%TYPE

55: , parent_receive_txn_id RCV_TRANSACTIONS.transaction_id%TYPE
56: , parent_deliver_txn_id RCV_TRANSACTIONS.transaction_id%TYPE
57:
58: -- org_id of the PO/CWK
59: , org_id PO_HEADERS_ALL.org_id%TYPE
60:
61: -- save the purchasing category attribute_id to attach to error messages
62: , time_attribute_id HXC_TIME_ATTRIBUTES.time_attribute_id%TYPE
63:

Line 86: ( po_header_id PO_HEADERS_ALL.po_header_id%TYPE

82:
83: -- cache records for use in caches
84:
85: TYPE po_header_cr IS RECORD
86: ( po_header_id PO_HEADERS_ALL.po_header_id%TYPE
87: , segment1 PO_HEADERS_ALL.segment1%TYPE
88: , user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE
89: , org_id PO_HEADERS_ALL.org_id%TYPE
90: , vendor_id PO_HEADERS_ALL.vendor_id%TYPE

Line 87: , segment1 PO_HEADERS_ALL.segment1%TYPE

83: -- cache records for use in caches
84:
85: TYPE po_header_cr IS RECORD
86: ( po_header_id PO_HEADERS_ALL.po_header_id%TYPE
87: , segment1 PO_HEADERS_ALL.segment1%TYPE
88: , user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE
89: , org_id PO_HEADERS_ALL.org_id%TYPE
90: , vendor_id PO_HEADERS_ALL.vendor_id%TYPE
91: , vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE

Line 88: , user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE

84:
85: TYPE po_header_cr IS RECORD
86: ( po_header_id PO_HEADERS_ALL.po_header_id%TYPE
87: , segment1 PO_HEADERS_ALL.segment1%TYPE
88: , user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE
89: , org_id PO_HEADERS_ALL.org_id%TYPE
90: , vendor_id PO_HEADERS_ALL.vendor_id%TYPE
91: , vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE
92: );

Line 89: , org_id PO_HEADERS_ALL.org_id%TYPE

85: TYPE po_header_cr IS RECORD
86: ( po_header_id PO_HEADERS_ALL.po_header_id%TYPE
87: , segment1 PO_HEADERS_ALL.segment1%TYPE
88: , user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE
89: , org_id PO_HEADERS_ALL.org_id%TYPE
90: , vendor_id PO_HEADERS_ALL.vendor_id%TYPE
91: , vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE
92: );
93:

Line 90: , vendor_id PO_HEADERS_ALL.vendor_id%TYPE

86: ( po_header_id PO_HEADERS_ALL.po_header_id%TYPE
87: , segment1 PO_HEADERS_ALL.segment1%TYPE
88: , user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE
89: , org_id PO_HEADERS_ALL.org_id%TYPE
90: , vendor_id PO_HEADERS_ALL.vendor_id%TYPE
91: , vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE
92: );
93:
94: -- Combine PO line/shipment info into a single record because

Line 91: , vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE

87: , segment1 PO_HEADERS_ALL.segment1%TYPE
88: , user_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE
89: , org_id PO_HEADERS_ALL.org_id%TYPE
90: , vendor_id PO_HEADERS_ALL.vendor_id%TYPE
91: , vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE
92: );
93:
94: -- Combine PO line/shipment info into a single record because
95: -- there is a 1-1 mapping between line and shipment for

Line 601: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

597: RETURN g_group_id;
598: END get_group_id;
599:
600: FUNCTION get_po_header
601: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
602: ) RETURN po_header_cr IS
603: BEGIN
604: g_po_header_calls := g_po_header_calls + 1;
605:

Line 621: FROM po_headers_all poh

617: , g_po_header_cache(p_po_header_id).user_hold_flag
618: , g_po_header_cache(p_po_header_id).org_id
619: , g_po_header_cache(p_po_header_id).vendor_id
620: , g_po_header_cache(p_po_header_id).vendor_site_id
621: FROM po_headers_all poh
622: WHERE poh.po_header_id = p_po_header_id;
623: END IF;
624:
625: RETURN g_po_header_cache(p_po_header_id);

Line 902: , po_headers_all ph

898: UNION
899: SELECT effective_start_date , effective_end_date
900: FROM per_all_assignments_f paaf
901: , po_cwk_associations pca
902: , po_headers_all ph
903: , po_lines_all pl
904: WHERE pca.po_line_id = :po_line_id
905: AND pca.cwk_person_id = :person_id
906: AND pca.po_line_id = pl.po_line_id

Line 1268: FROM po_headers_all

1264: SELECT 'Y'
1265: INTO po_update_flag
1266: FROM dual
1267: WHERE EXISTS (SELECT segment1
1268: FROM po_headers_all
1269: WHERE segment1=p_attributes.po_number
1270: AND org_id=hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1271: AND Nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
1272: AND Nvl(user_hold_flag,'N') <> 'Y'

Line 2822: FROM po_headers

2818:
2819: --added for bugfix 5609476
2820: CURSOR c_get_currency_code(v_po_header_id NUMBER) IS
2821: SELECT currency_code
2822: FROM po_headers
2823: where po_header_id = v_po_header_id;
2824:
2825: -- for 8i compatibility, we can only do BULK INSERT using an array for each column
2826: TYPE header_interface_id_tbl IS TABLE OF RCV_HEADERS_INTERFACE.header_interface_id%TYPE INDEX BY BINARY_INTEGER;

Line 4687: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */

4683: l_start_date := FND_DATE.Canonical_To_Date(p_start_date);
4684: l_end_date := FND_DATE.Canonical_To_Date(p_end_date);
4685: l_receipt_date := FND_DATE.Canonical_To_Date(p_receipt_date);
4686:
4687: /* Bug 5713531 .Change made in where clause as po_headers and po_lines */
4688: -- add supplier name condition
4689: -- bug 6031665 : corrected the syntax error. Previously the in condition was
4690: -- in ("RATE", "FIXED PRICE") instead of in (''RATE'', ''FIXED PRICE'')
4691: IF p_vendor_id IS NOT NULL THEN

Line 4694: FROM po_headers poh, po_lines pol

4690: -- in ("RATE", "FIXED PRICE") instead of in (''RATE'', ''FIXED PRICE'')
4691: IF p_vendor_id IS NOT NULL THEN
4692: Add_Where_Clause( p_where_clause => l_where_clause
4693: , p_new_condition => '[PO Line Id]{ IN (SELECT TO_CHAR(pol.po_line_id)
4694: FROM po_headers poh, po_lines pol
4695: WHERE poh.po_header_id = pol.po_header_id
4696: AND pol.order_type_lookup_code in (''RATE'',''FIXED PRICE'') and poh.vendor_id = '
4697: || p_vendor_id || ')}');
4698: /* Else clause also added to impose OU specific behaviour */