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

Line 6: line_num po_requisition_lines.line_num%TYPE,

2: /* $Header: POXWPA8B.pls 120.0 2005/06/01 14:15:15 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 759: l_document_id po_requisition_lines.requisition_header_id%TYPE;

755:
756: l_item_type wf_items.item_type%TYPE;
757: l_item_key wf_items.item_key%TYPE;
758:
759: l_document_id po_requisition_lines.requisition_header_id%TYPE;
760: l_org_id po_requisition_lines.org_id%TYPE;
761:
762: l_line line_record;
763:

Line 760: l_org_id po_requisition_lines.org_id%TYPE;

756: l_item_type wf_items.item_type%TYPE;
757: l_item_key wf_items.item_key%TYPE;
758:
759: l_document_id po_requisition_lines.requisition_header_id%TYPE;
760: l_org_id po_requisition_lines.org_id%TYPE;
761:
762: l_line line_record;
763:
764: l_document VARCHAR2(32000) := '';

Line 789: FROM po_requisition_lines rql,

785: hrt.location_code,
786: per.full_name,
787: rql.suggested_vendor_name,
788: rql.suggested_vendor_location
789: FROM po_requisition_lines rql,
790: mtl_system_items_kfv msi,
791: hr_locations hrt,
792: per_people_f per
793: WHERE rql.requisition_header_id = v_document_id

Line 817: FROM po_requisition_lines rql,

813: hrt.location_code,
814: per.full_name,
815: rql.suggested_vendor_name,
816: rql.suggested_vendor_location
817: FROM po_requisition_lines rql,
818: hr_locations hrt,
819: per_people_f per
820: WHERE rql.requisition_header_id = v_document_id
821: AND NVL(rql.cancel_flag,'N') = 'N'

Line 1027: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1023:
1024: l_item_type wf_items.item_type%TYPE;
1025: l_item_key wf_items.item_key%TYPE;
1026:
1027: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1028: l_org_id po_requisition_lines.org_id%TYPE;
1029:
1030: l_line line_record;
1031:

Line 1028: l_org_id po_requisition_lines.org_id%TYPE;

1024: l_item_type wf_items.item_type%TYPE;
1025: l_item_key wf_items.item_key%TYPE;
1026:
1027: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1028: l_org_id po_requisition_lines.org_id%TYPE;
1029:
1030: l_line line_record;
1031:
1032: l_document VARCHAR2(32000) := '';

Line 1057: FROM po_requisition_lines rql,

1053: hrt.location_code,
1054: per.full_name,
1055: rql.suggested_vendor_name,
1056: rql.suggested_vendor_location
1057: FROM po_requisition_lines rql,
1058: mtl_system_items_kfv msi,
1059: hr_locations hrt,
1060: per_people_f per
1061: WHERE rql.requisition_header_id = v_document_id

Line 1085: FROM po_requisition_lines rql,

1081: hrt.location_code,
1082: per.full_name,
1083: rql.suggested_vendor_name,
1084: rql.suggested_vendor_location
1085: FROM po_requisition_lines rql,
1086: hr_locations hrt,
1087: per_people_f per
1088: WHERE rql.requisition_header_id = v_document_id
1089: AND NVL(rql.cancel_flag,'N') = 'N'

Line 1281: l_document_id po_requisition_lines.requisition_header_id%TYPE;

1277:
1278: l_item_type wf_items.item_type%TYPE;
1279: l_item_key wf_items.item_key%TYPE;
1280:
1281: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1282: l_object_type po_action_history.object_type_code%TYPE;
1283: l_org_id po_requisition_lines.org_id%TYPE;
1284:
1285: l_document VARCHAR2(32000) := '';

Line 1283: l_org_id po_requisition_lines.org_id%TYPE;

1279: l_item_key wf_items.item_key%TYPE;
1280:
1281: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1282: l_object_type po_action_history.object_type_code%TYPE;
1283: l_org_id po_requisition_lines.org_id%TYPE;
1284:
1285: l_document VARCHAR2(32000) := '';
1286:
1287: l_history history_record;