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.GML_PO_INTERFACE dependencies on PO_HEADERS_ALL

Line 48: po_headers_all table

44: p_shipment_num IN NUMBER
45: ) IS
46:
47: /* Definitions for variables that are derived from columns of
48: po_headers_all table
49: T. Ricci 5/11/98 added v_created_by, v_last_updated_by, v_last_update_login
50: for GEMMS 5.0 who columns */
51:
52: /* T.Ricci 10/15/98 added v_terms_name for terms code fix for OPM 11.0

Line 55: v_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;

51:
52: /* T.Ricci 10/15/98 added v_terms_name for terms code fix for OPM 11.0
53: T.Ricci 11/10/98 added v_shipper_code for OPM 11.0
54: T.Ricci 11/11/98 added v_fob_code for OPM 11.0*/
55: v_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
56: v_old_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
57: /* HW BUG#:1107267 - new variable to hold rate */
58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;
59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

Line 56: v_old_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;

52: /* T.Ricci 10/15/98 added v_terms_name for terms code fix for OPM 11.0
53: T.Ricci 11/10/98 added v_shipper_code for OPM 11.0
54: T.Ricci 11/11/98 added v_fob_code for OPM 11.0*/
55: v_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
56: v_old_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
57: /* HW BUG#:1107267 - new variable to hold rate */
58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;
59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;

Line 58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;

54: T.Ricci 11/11/98 added v_fob_code for OPM 11.0*/
55: v_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
56: v_old_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
57: /* HW BUG#:1107267 - new variable to hold rate */
58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;
59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;

Line 59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

55: v_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
56: v_old_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
57: /* HW BUG#:1107267 - new variable to hold rate */
58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;
59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;

Line 60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;

56: v_old_po_no PO_HEADERS_ALL.SEGMENT1%TYPE;
57: /* HW BUG#:1107267 - new variable to hold rate */
58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;
59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;

Line 61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;

57: /* HW BUG#:1107267 - new variable to hold rate */
58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;
59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;

Line 62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;

58: v_exchange_rate PO_HEADERS_ALL.RATE%TYPE;
59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;

Line 63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;

59: v_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

Line 64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;

60: v_last_update_date PO_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;

Line 65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;

61: v_creation_date PO_HEADERS_ALL.CREATION_DATE%TYPE;
62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;

Line 66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;

62: v_print_count PO_HEADERS_ALL.PRINT_COUNT%TYPE;
63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;

Line 67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

63: v_revision_num PO_HEADERS_ALL.REVISION_NUM%TYPE;
64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

Line 68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;

64: v_printed_date PO_HEADERS_ALL.PRINTED_DATE%TYPE;
65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;

Line 69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;

65: v_approved_date PO_HEADERS_ALL.APPROVED_DATE%TYPE;
66: v_agent_id PO_HEADERS_ALL.AGENT_ID%TYPE;
67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;
73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;

Line 71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

67: v_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;
73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;
74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
75: v_gemms_orgn_code VARCHAR2(4);

Line 72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;

68: v_bill_to_location_id PO_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE;
69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;
73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;
74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
75: v_gemms_orgn_code VARCHAR2(4);
76: v_opm_rel_orgn_code VARCHAR2(4);

Line 73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;

69: v_terms_id PO_HEADERS_ALL.TERMS_ID%TYPE;
70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;
73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;
74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
75: v_gemms_orgn_code VARCHAR2(4);
76: v_opm_rel_orgn_code VARCHAR2(4);
77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;

Line 74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;

70: v_terms_name AP_TERMS.NAME%TYPE;
71: v_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
72: v_start_date PO_HEADERS_ALL.START_DATE%TYPE;
73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;
74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
75: v_gemms_orgn_code VARCHAR2(4);
76: v_opm_rel_orgn_code VARCHAR2(4);
77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;
78: v_created_by PO_HEADERS_ALL.CREATED_BY%TYPE;

Line 77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;

73: v_end_date PO_HEADERS_ALL.END_DATE%TYPE;
74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
75: v_gemms_orgn_code VARCHAR2(4);
76: v_opm_rel_orgn_code VARCHAR2(4);
77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;
78: v_created_by PO_HEADERS_ALL.CREATED_BY%TYPE;
79: v_last_updated_by PO_HEADERS_ALL.LAST_UPDATED_BY%TYPE;
80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;
81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */

Line 78: v_created_by PO_HEADERS_ALL.CREATED_BY%TYPE;

74: v_terms_code PO_HEADERS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
75: v_gemms_orgn_code VARCHAR2(4);
76: v_opm_rel_orgn_code VARCHAR2(4);
77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;
78: v_created_by PO_HEADERS_ALL.CREATED_BY%TYPE;
79: v_last_updated_by PO_HEADERS_ALL.LAST_UPDATED_BY%TYPE;
80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;
81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */
82:

Line 79: v_last_updated_by PO_HEADERS_ALL.LAST_UPDATED_BY%TYPE;

75: v_gemms_orgn_code VARCHAR2(4);
76: v_opm_rel_orgn_code VARCHAR2(4);
77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;
78: v_created_by PO_HEADERS_ALL.CREATED_BY%TYPE;
79: v_last_updated_by PO_HEADERS_ALL.LAST_UPDATED_BY%TYPE;
80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;
81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */
82:
83: v_shipper_code OP_SHIP_MST.SHIPPER_CODE%TYPE;

Line 80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;

76: v_opm_rel_orgn_code VARCHAR2(4);
77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;
78: v_created_by PO_HEADERS_ALL.CREATED_BY%TYPE;
79: v_last_updated_by PO_HEADERS_ALL.LAST_UPDATED_BY%TYPE;
80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;
81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */
82:
83: v_shipper_code OP_SHIP_MST.SHIPPER_CODE%TYPE;
84: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;

Line 81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */

77: v_blanket_total_amount PO_HEADERS_ALL.BLANKET_TOTAL_AMOUNT%TYPE;
78: v_created_by PO_HEADERS_ALL.CREATED_BY%TYPE;
79: v_last_updated_by PO_HEADERS_ALL.LAST_UPDATED_BY%TYPE;
80: v_last_update_login PO_HEADERS_ALL.LAST_UPDATE_LOGIN%TYPE;
81: v_opm_rel_exchg_rate PO_HEADERS_ALL.RATE%TYPE; /* Bug 1427876 */
82:
83: v_shipper_code OP_SHIP_MST.SHIPPER_CODE%TYPE;
84: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;
85: /** MC BUG# 1554088 **/

Line 176: /* Cursor to select values from po_headers_all

172: SELECT upper(substrb(last_name ,1,35))
173: FROM per_people_f
174: WHERE person_id=v_agent_id;
175:
176: /* Cursor to select values from po_headers_all
177: T. Ricci 5/11/98 added created_by, last_updated_by, last_update_login
178: for GEMMS 5.0 who columns */
179:
180: CURSOR hdr_vars_cur

Line 192: FROM po_headers_all

188: fob_lookup_code, ship_via_lookup_code,
189: freight_terms_lookup_code, substrb(attribute15,1,4) gemms_orgn_code,
190: blanket_total_amount, created_by, last_updated_by,
191: last_update_login,rate
192: FROM po_headers_all
193: WHERE po_header_id = p_po_header_id;
194:
195: /* Cursor to select location code */
196: /* Bug# 1200791 Previously it was this cursor -- after the warehouse modification this

Line 418: release, else the v_gemms_orgn_code will be from the PO_HEADERS_ALL

414: END IF;
415:
416: -- Begin B1410454
417: /* Select the OPM orgn Code from the PO_RELEASES_ALL table, if it is
418: release, else the v_gemms_orgn_code will be from the PO_HEADERS_ALL
419: table for all other purposes. If the v_opm_rel_orgn_code is NOT NULL
420: then it will be used , else the v_gemms_orgn_code from the PO_HEAD
421: ERS_ALL will be used */
422:

Line 703: it is fetching from segment1 from po_headers_all but for migrated PO's segment1

699: /** MC BUG# 1625573 **/
700: /** changed bug no. from 1527076 to 1625573 **/
701: /** cpg_purchasing_interface should have po_no column with value = OPM PO. Right
702: now
703: it is fetching from segment1 from po_headers_all but for migrated PO's segment1
704: can be different than OPM PO. so pick up the correct po no from cpg_oragems_mapp
705: ing table **/
706:
707: /* Uday Phadtare B2038851 following update statement commented */