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_ALL

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 591: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

587: RETURN g_group_id;
588: END get_group_id;
589:
590: FUNCTION get_po_header
591: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
592: ) RETURN po_header_cr IS
593: BEGIN
594: g_po_header_calls := g_po_header_calls + 1;
595:

Line 611: FROM po_headers_all poh

607: , g_po_header_cache(p_po_header_id).user_hold_flag
608: , g_po_header_cache(p_po_header_id).org_id
609: , g_po_header_cache(p_po_header_id).vendor_id
610: , g_po_header_cache(p_po_header_id).vendor_site_id
611: FROM po_headers_all poh
612: WHERE poh.po_header_id = p_po_header_id;
613: END IF;
614:
615: RETURN g_po_header_cache(p_po_header_id);

Line 894: po_headers_all ph,

890: UNION
891: SELECT effective_start_date , effective_end_date
892: FROM per_all_assignments_f paaf,
893: po_cwk_associations pca,
894: po_headers_all ph,
895: po_lines_all pl
896: WHERE pca.po_line_id = :po_line_id
897: AND pca.cwk_person_id = :person_id
898: AND pca.po_line_id = pl.po_line_id

Line 1228: FROM po_headers_all

1224: SELECT 'Y'
1225: INTO po_update_flag
1226: FROM dual
1227: WHERE EXISTS (SELECT segment1
1228: FROM po_headers_all
1229: WHERE segment1=p_attributes.po_number
1230: AND org_id=hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1231: AND Nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
1232: AND Nvl(user_hold_flag,'N') <> 'Y'