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_WF_DOCUMENT dependencies on PO_REQUISITION_LINES

Line 6: line_num po_requisition_lines.line_num%TYPE,

2: /* $Header: POXWMSGB.pls 120.0 2005/06/01 13:27:09 appldev noship $ */
3:
4: TYPE line_record IS RECORD (
5:
6: line_num po_requisition_lines.line_num%TYPE,
7: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
8: item_revision po_requisition_lines.item_revision%TYPE,
9: item_desc po_requisition_lines.item_description%TYPE,
10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,

Line 8: item_revision po_requisition_lines.item_revision%TYPE,

4: TYPE line_record IS RECORD (
5:
6: line_num po_requisition_lines.line_num%TYPE,
7: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
8: item_revision po_requisition_lines.item_revision%TYPE,
9: item_desc po_requisition_lines.item_description%TYPE,
10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
11: quantity po_requisition_lines.quantity%TYPE,
12: unit_price po_requisition_lines.unit_price%TYPE,

Line 9: item_desc po_requisition_lines.item_description%TYPE,

5:
6: line_num po_requisition_lines.line_num%TYPE,
7: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
8: item_revision po_requisition_lines.item_revision%TYPE,
9: item_desc po_requisition_lines.item_description%TYPE,
10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
11: quantity po_requisition_lines.quantity%TYPE,
12: unit_price po_requisition_lines.unit_price%TYPE,
13: line_amount NUMBER,

Line 10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,

6: line_num po_requisition_lines.line_num%TYPE,
7: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
8: item_revision po_requisition_lines.item_revision%TYPE,
9: item_desc po_requisition_lines.item_description%TYPE,
10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
11: quantity po_requisition_lines.quantity%TYPE,
12: unit_price po_requisition_lines.unit_price%TYPE,
13: line_amount NUMBER,
14: need_by_date po_requisition_lines.need_by_date%TYPE,

Line 11: quantity po_requisition_lines.quantity%TYPE,

7: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
8: item_revision po_requisition_lines.item_revision%TYPE,
9: item_desc po_requisition_lines.item_description%TYPE,
10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
11: quantity po_requisition_lines.quantity%TYPE,
12: unit_price po_requisition_lines.unit_price%TYPE,
13: line_amount NUMBER,
14: need_by_date po_requisition_lines.need_by_date%TYPE,
15: location hr_locations.location_code%TYPE,

Line 12: unit_price po_requisition_lines.unit_price%TYPE,

8: item_revision po_requisition_lines.item_revision%TYPE,
9: item_desc po_requisition_lines.item_description%TYPE,
10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
11: quantity po_requisition_lines.quantity%TYPE,
12: unit_price po_requisition_lines.unit_price%TYPE,
13: line_amount NUMBER,
14: need_by_date po_requisition_lines.need_by_date%TYPE,
15: location hr_locations.location_code%TYPE,
16: requestor per_people_f.full_name%TYPE,

Line 14: need_by_date po_requisition_lines.need_by_date%TYPE,

10: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
11: quantity po_requisition_lines.quantity%TYPE,
12: unit_price po_requisition_lines.unit_price%TYPE,
13: line_amount NUMBER,
14: need_by_date po_requisition_lines.need_by_date%TYPE,
15: location hr_locations.location_code%TYPE,
16: requestor per_people_f.full_name%TYPE,
17: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
18: sugg_site po_requisition_lines.suggested_vendor_location%TYPE);

Line 17: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,

13: line_amount NUMBER,
14: need_by_date po_requisition_lines.need_by_date%TYPE,
15: location hr_locations.location_code%TYPE,
16: requestor per_people_f.full_name%TYPE,
17: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
18: sugg_site po_requisition_lines.suggested_vendor_location%TYPE);
19:
20: TYPE history_record IS RECORD (
21:

Line 18: sugg_site po_requisition_lines.suggested_vendor_location%TYPE);

14: need_by_date po_requisition_lines.need_by_date%TYPE,
15: location hr_locations.location_code%TYPE,
16: requestor per_people_f.full_name%TYPE,
17: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
18: sugg_site po_requisition_lines.suggested_vendor_location%TYPE);
19:
20: TYPE history_record IS RECORD (
21:
22: seq_num po_action_history_v.sequence_num%TYPE,

Line 150: FROM po_requisition_lines rl,

146: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
147:
148: SELECT nvl(sum(nonrecoverable_tax), 0)
149: INTO l_tax_amt
150: FROM po_requisition_lines rl,
151: po_req_distributions_all rd --
152: WHERE rl.requisition_header_id = l_document_id
153: AND rd.requisition_line_id = rl.requisition_line_id;
154:

Line 355: FROM po_requisition_lines rl,

351: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
352:
353: SELECT nvl(sum(nonrecoverable_tax), 0)
354: INTO l_tax_amt
355: FROM po_requisition_lines rl,
356: po_req_distributions_all rd --
357: WHERE rl.requisition_header_id = l_document_id
358: AND rd.requisition_line_id = rl.requisition_line_id;
359:

Line 560: FROM po_requisition_lines rl,

556: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
557:
558: SELECT nvl(sum(nonrecoverable_tax), 0)
559: INTO l_tax_amt
560: FROM po_requisition_lines rl,
561: po_req_distributions_all rd --
562: WHERE rl.requisition_header_id = l_document_id
563: AND rd.requisition_line_id = rl.requisition_line_id;
564:

Line 765: FROM po_requisition_lines rl,

761: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
762:
763: SELECT nvl(sum(nonrecoverable_tax), 0)
764: INTO l_tax_amt
765: FROM po_requisition_lines rl,
766: po_req_distributions_all rd --
767: WHERE rl.requisition_header_id = l_document_id
768: AND rd.requisition_line_id = rl.requisition_line_id;
769:

Line 867: l_document_id po_requisition_lines.requisition_header_id%TYPE;

863:
864: l_item_type wf_items.item_type%TYPE;
865: l_item_key wf_items.item_key%TYPE;
866:
867: l_document_id po_requisition_lines.requisition_header_id%TYPE;
868: l_org_id po_requisition_lines.org_id%TYPE;
869:
870: l_line line_record;
871:

Line 868: l_org_id po_requisition_lines.org_id%TYPE;

864: l_item_type wf_items.item_type%TYPE;
865: l_item_key wf_items.item_key%TYPE;
866:
867: l_document_id po_requisition_lines.requisition_header_id%TYPE;
868: l_org_id po_requisition_lines.org_id%TYPE;
869:
870: l_line line_record;
871:
872: l_document VARCHAR2(32000) := '';

Line 892: FROM po_requisition_lines rql,

888: hrt.location_code,
889: per.full_name,
890: rql.suggested_vendor_name,
891: rql.suggested_vendor_location
892: FROM po_requisition_lines rql,
893: mtl_system_items_kfv msi,
894: hr_locations hrt,
895: per_people_f per
896: WHERE rql.requisition_header_id = v_document_id

Line 1023: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1019:
1020: l_item_type wf_items.item_type%TYPE;
1021: l_item_key wf_items.item_key%TYPE;
1022:
1023: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1024: l_object_type po_action_history.object_type_code%TYPE;
1025: l_org_id po_requisition_lines.org_id%TYPE;
1026:
1027: l_document VARCHAR2(32000) := '';

Line 1025: l_org_id po_requisition_lines.org_id%TYPE;

1021: l_item_key wf_items.item_key%TYPE;
1022:
1023: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1024: l_object_type po_action_history.object_type_code%TYPE;
1025: l_org_id po_requisition_lines.org_id%TYPE;
1026:
1027: l_document VARCHAR2(32000) := '';
1028:
1029: l_history history_record;