24: -- Alligned the spec so that it is more readable for troubleshooting.
25:
26: TYPE r_vendor_rec_type IS RECORD(
27: VENDOR_ID NUMBER,
28: SEGMENT1 AP_SUPPLIERS.SEGMENT1%TYPE,
29: VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE,
30: VENDOR_NAME_ALT AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
25:
26: TYPE r_vendor_rec_type IS RECORD(
27: VENDOR_ID NUMBER,
28: SEGMENT1 AP_SUPPLIERS.SEGMENT1%TYPE,
29: VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE,
30: VENDOR_NAME_ALT AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
26: TYPE r_vendor_rec_type IS RECORD(
27: VENDOR_ID NUMBER,
28: SEGMENT1 AP_SUPPLIERS.SEGMENT1%TYPE,
29: VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE,
30: VENDOR_NAME_ALT AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
27: VENDOR_ID NUMBER,
28: SEGMENT1 AP_SUPPLIERS.SEGMENT1%TYPE,
29: VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE,
30: VENDOR_NAME_ALT AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
28: SEGMENT1 AP_SUPPLIERS.SEGMENT1%TYPE,
29: VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE,
30: VENDOR_NAME_ALT AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
29: VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE,
30: VENDOR_NAME_ALT AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
37: EMPLOYEE_ID NUMBER,
30: VENDOR_NAME_ALT AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
37: EMPLOYEE_ID NUMBER,
38: VENDOR_TYPE_LOOKUP_CODE AP_SUPPLIERS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
31: SUMMARY_FLAG AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
37: EMPLOYEE_ID NUMBER,
38: VENDOR_TYPE_LOOKUP_CODE AP_SUPPLIERS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
39: CUSTOMER_NUM AP_SUPPLIERS.CUSTOMER_NUM%TYPE,
32: ENABLED_FLAG AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33: SEGMENT2 AP_SUPPLIERS.SEGMENT2%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
37: EMPLOYEE_ID NUMBER,
38: VENDOR_TYPE_LOOKUP_CODE AP_SUPPLIERS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
39: CUSTOMER_NUM AP_SUPPLIERS.CUSTOMER_NUM%TYPE,
40: ONE_TIME_FLAG AP_SUPPLIERS.ONE_TIME_FLAG%TYPE,
34: SEGMENT3 AP_SUPPLIERS.SEGMENT3%TYPE,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
37: EMPLOYEE_ID NUMBER,
38: VENDOR_TYPE_LOOKUP_CODE AP_SUPPLIERS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
39: CUSTOMER_NUM AP_SUPPLIERS.CUSTOMER_NUM%TYPE,
40: ONE_TIME_FLAG AP_SUPPLIERS.ONE_TIME_FLAG%TYPE,
41: PARENT_VENDOR_ID NUMBER,
42: MIN_ORDER_AMOUNT NUMBER,
35: SEGMENT4 AP_SUPPLIERS.SEGMENT4%TYPE,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
37: EMPLOYEE_ID NUMBER,
38: VENDOR_TYPE_LOOKUP_CODE AP_SUPPLIERS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
39: CUSTOMER_NUM AP_SUPPLIERS.CUSTOMER_NUM%TYPE,
40: ONE_TIME_FLAG AP_SUPPLIERS.ONE_TIME_FLAG%TYPE,
41: PARENT_VENDOR_ID NUMBER,
42: MIN_ORDER_AMOUNT NUMBER,
43: TERMS_ID NUMBER,
36: SEGMENT5 AP_SUPPLIERS.SEGMENT5%TYPE,
37: EMPLOYEE_ID NUMBER,
38: VENDOR_TYPE_LOOKUP_CODE AP_SUPPLIERS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
39: CUSTOMER_NUM AP_SUPPLIERS.CUSTOMER_NUM%TYPE,
40: ONE_TIME_FLAG AP_SUPPLIERS.ONE_TIME_FLAG%TYPE,
41: PARENT_VENDOR_ID NUMBER,
42: MIN_ORDER_AMOUNT NUMBER,
43: TERMS_ID NUMBER,
44: SET_OF_BOOKS_ID NUMBER,
41: PARENT_VENDOR_ID NUMBER,
42: MIN_ORDER_AMOUNT NUMBER,
43: TERMS_ID NUMBER,
44: SET_OF_BOOKS_ID NUMBER,
45: ALWAYS_TAKE_DISC_FLAG AP_SUPPLIERS.ALWAYS_TAKE_DISC_FLAG%TYPE,
46: PAY_DATE_BASIS_LOOKUP_CODE AP_SUPPLIERS.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
47: PAY_GROUP_LOOKUP_CODE AP_SUPPLIERS.PAY_GROUP_LOOKUP_CODE%TYPE,
48: PAYMENT_PRIORITY NUMBER,
49: INVOICE_CURRENCY_CODE AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
42: MIN_ORDER_AMOUNT NUMBER,
43: TERMS_ID NUMBER,
44: SET_OF_BOOKS_ID NUMBER,
45: ALWAYS_TAKE_DISC_FLAG AP_SUPPLIERS.ALWAYS_TAKE_DISC_FLAG%TYPE,
46: PAY_DATE_BASIS_LOOKUP_CODE AP_SUPPLIERS.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
47: PAY_GROUP_LOOKUP_CODE AP_SUPPLIERS.PAY_GROUP_LOOKUP_CODE%TYPE,
48: PAYMENT_PRIORITY NUMBER,
49: INVOICE_CURRENCY_CODE AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
50: PAYMENT_CURRENCY_CODE AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
43: TERMS_ID NUMBER,
44: SET_OF_BOOKS_ID NUMBER,
45: ALWAYS_TAKE_DISC_FLAG AP_SUPPLIERS.ALWAYS_TAKE_DISC_FLAG%TYPE,
46: PAY_DATE_BASIS_LOOKUP_CODE AP_SUPPLIERS.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
47: PAY_GROUP_LOOKUP_CODE AP_SUPPLIERS.PAY_GROUP_LOOKUP_CODE%TYPE,
48: PAYMENT_PRIORITY NUMBER,
49: INVOICE_CURRENCY_CODE AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
50: PAYMENT_CURRENCY_CODE AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
51: INVOICE_AMOUNT_LIMIT NUMBER,
45: ALWAYS_TAKE_DISC_FLAG AP_SUPPLIERS.ALWAYS_TAKE_DISC_FLAG%TYPE,
46: PAY_DATE_BASIS_LOOKUP_CODE AP_SUPPLIERS.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
47: PAY_GROUP_LOOKUP_CODE AP_SUPPLIERS.PAY_GROUP_LOOKUP_CODE%TYPE,
48: PAYMENT_PRIORITY NUMBER,
49: INVOICE_CURRENCY_CODE AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
50: PAYMENT_CURRENCY_CODE AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
51: INVOICE_AMOUNT_LIMIT NUMBER,
52: HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
46: PAY_DATE_BASIS_LOOKUP_CODE AP_SUPPLIERS.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
47: PAY_GROUP_LOOKUP_CODE AP_SUPPLIERS.PAY_GROUP_LOOKUP_CODE%TYPE,
48: PAYMENT_PRIORITY NUMBER,
49: INVOICE_CURRENCY_CODE AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
50: PAYMENT_CURRENCY_CODE AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
51: INVOICE_AMOUNT_LIMIT NUMBER,
52: HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
48: PAYMENT_PRIORITY NUMBER,
49: INVOICE_CURRENCY_CODE AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
50: PAYMENT_CURRENCY_CODE AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
51: INVOICE_AMOUNT_LIMIT NUMBER,
52: HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
49: INVOICE_CURRENCY_CODE AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
50: PAYMENT_CURRENCY_CODE AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
51: INVOICE_AMOUNT_LIMIT NUMBER,
52: HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
50: PAYMENT_CURRENCY_CODE AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
51: INVOICE_AMOUNT_LIMIT NUMBER,
52: HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
51: INVOICE_AMOUNT_LIMIT NUMBER,
52: HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
52: HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
53: HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
54: HOLD_REASON AP_SUPPLIERS.HOLD_REASON%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
55: TYPE_1099 AP_SUPPLIERS.TYPE_1099%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
56: WITHHOLDING_STATUS_LOOKUP_CODE AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
57: WITHHOLDING_START_DATE AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
58: ORGANIZATION_TYPE_LOOKUP_CODE AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66: HOLD_BY NUMBER,
59: START_DATE_ACTIVE AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66: HOLD_BY NUMBER,
67: HOLD_DATE AP_SUPPLIERS.HOLD_DATE%TYPE,
60: END_DATE_ACTIVE AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66: HOLD_BY NUMBER,
67: HOLD_DATE AP_SUPPLIERS.HOLD_DATE%TYPE,
68: TERMS_DATE_BASIS AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
61: MINORITY_GROUP_LOOKUP_CODE AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62: WOMEN_OWNED_FLAG AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66: HOLD_BY NUMBER,
67: HOLD_DATE AP_SUPPLIERS.HOLD_DATE%TYPE,
68: TERMS_DATE_BASIS AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
69: INSPECTION_REQUIRED_FLAG AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
63: SMALL_BUSINESS_FLAG AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66: HOLD_BY NUMBER,
67: HOLD_DATE AP_SUPPLIERS.HOLD_DATE%TYPE,
68: TERMS_DATE_BASIS AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
69: INSPECTION_REQUIRED_FLAG AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
70: RECEIPT_REQUIRED_FLAG AP_SUPPLIERS.RECEIPT_REQUIRED_FLAG%TYPE,
71: QTY_RCV_TOLERANCE NUMBER,
64: HOLD_FLAG AP_SUPPLIERS.HOLD_FLAG%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66: HOLD_BY NUMBER,
67: HOLD_DATE AP_SUPPLIERS.HOLD_DATE%TYPE,
68: TERMS_DATE_BASIS AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
69: INSPECTION_REQUIRED_FLAG AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
70: RECEIPT_REQUIRED_FLAG AP_SUPPLIERS.RECEIPT_REQUIRED_FLAG%TYPE,
71: QTY_RCV_TOLERANCE NUMBER,
72: QTY_RCV_EXCEPTION_CODE AP_SUPPLIERS.QTY_RCV_EXCEPTION_CODE%TYPE,
65: PURCHASING_HOLD_REASON AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66: HOLD_BY NUMBER,
67: HOLD_DATE AP_SUPPLIERS.HOLD_DATE%TYPE,
68: TERMS_DATE_BASIS AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
69: INSPECTION_REQUIRED_FLAG AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
70: RECEIPT_REQUIRED_FLAG AP_SUPPLIERS.RECEIPT_REQUIRED_FLAG%TYPE,
71: QTY_RCV_TOLERANCE NUMBER,
72: QTY_RCV_EXCEPTION_CODE AP_SUPPLIERS.QTY_RCV_EXCEPTION_CODE%TYPE,
73: ENFORCE_SHIP_TO_LOCATION_CODE AP_SUPPLIERS.ENFORCE_SHIP_TO_LOCATION_CODE%TYPE,
66: HOLD_BY NUMBER,
67: HOLD_DATE AP_SUPPLIERS.HOLD_DATE%TYPE,
68: TERMS_DATE_BASIS AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
69: INSPECTION_REQUIRED_FLAG AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
70: RECEIPT_REQUIRED_FLAG AP_SUPPLIERS.RECEIPT_REQUIRED_FLAG%TYPE,
71: QTY_RCV_TOLERANCE NUMBER,
72: QTY_RCV_EXCEPTION_CODE AP_SUPPLIERS.QTY_RCV_EXCEPTION_CODE%TYPE,
73: ENFORCE_SHIP_TO_LOCATION_CODE AP_SUPPLIERS.ENFORCE_SHIP_TO_LOCATION_CODE%TYPE,
74: DAYS_EARLY_RECEIPT_ALLOWED NUMBER,
68: TERMS_DATE_BASIS AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
69: INSPECTION_REQUIRED_FLAG AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
70: RECEIPT_REQUIRED_FLAG AP_SUPPLIERS.RECEIPT_REQUIRED_FLAG%TYPE,
71: QTY_RCV_TOLERANCE NUMBER,
72: QTY_RCV_EXCEPTION_CODE AP_SUPPLIERS.QTY_RCV_EXCEPTION_CODE%TYPE,
73: ENFORCE_SHIP_TO_LOCATION_CODE AP_SUPPLIERS.ENFORCE_SHIP_TO_LOCATION_CODE%TYPE,
74: DAYS_EARLY_RECEIPT_ALLOWED NUMBER,
75: DAYS_LATE_RECEIPT_ALLOWED NUMBER,
76: RECEIPT_DAYS_EXCEPTION_CODE AP_SUPPLIERS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
69: INSPECTION_REQUIRED_FLAG AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
70: RECEIPT_REQUIRED_FLAG AP_SUPPLIERS.RECEIPT_REQUIRED_FLAG%TYPE,
71: QTY_RCV_TOLERANCE NUMBER,
72: QTY_RCV_EXCEPTION_CODE AP_SUPPLIERS.QTY_RCV_EXCEPTION_CODE%TYPE,
73: ENFORCE_SHIP_TO_LOCATION_CODE AP_SUPPLIERS.ENFORCE_SHIP_TO_LOCATION_CODE%TYPE,
74: DAYS_EARLY_RECEIPT_ALLOWED NUMBER,
75: DAYS_LATE_RECEIPT_ALLOWED NUMBER,
76: RECEIPT_DAYS_EXCEPTION_CODE AP_SUPPLIERS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
77: RECEIVING_ROUTING_ID NUMBER,
72: QTY_RCV_EXCEPTION_CODE AP_SUPPLIERS.QTY_RCV_EXCEPTION_CODE%TYPE,
73: ENFORCE_SHIP_TO_LOCATION_CODE AP_SUPPLIERS.ENFORCE_SHIP_TO_LOCATION_CODE%TYPE,
74: DAYS_EARLY_RECEIPT_ALLOWED NUMBER,
75: DAYS_LATE_RECEIPT_ALLOWED NUMBER,
76: RECEIPT_DAYS_EXCEPTION_CODE AP_SUPPLIERS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
77: RECEIVING_ROUTING_ID NUMBER,
78: ALLOW_SUBSTITUTE_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
79: ALLOW_UNORDERED_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
74: DAYS_EARLY_RECEIPT_ALLOWED NUMBER,
75: DAYS_LATE_RECEIPT_ALLOWED NUMBER,
76: RECEIPT_DAYS_EXCEPTION_CODE AP_SUPPLIERS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
77: RECEIVING_ROUTING_ID NUMBER,
78: ALLOW_SUBSTITUTE_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
79: ALLOW_UNORDERED_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
75: DAYS_LATE_RECEIPT_ALLOWED NUMBER,
76: RECEIPT_DAYS_EXCEPTION_CODE AP_SUPPLIERS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
77: RECEIVING_ROUTING_ID NUMBER,
78: ALLOW_SUBSTITUTE_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
79: ALLOW_UNORDERED_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
76: RECEIPT_DAYS_EXCEPTION_CODE AP_SUPPLIERS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
77: RECEIVING_ROUTING_ID NUMBER,
78: ALLOW_SUBSTITUTE_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
79: ALLOW_UNORDERED_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
77: RECEIVING_ROUTING_ID NUMBER,
78: ALLOW_SUBSTITUTE_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
79: ALLOW_UNORDERED_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
78: ALLOW_SUBSTITUTE_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
79: ALLOW_UNORDERED_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
79: ALLOW_UNORDERED_RECEIPTS_FLAG AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
80: HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
81: TAX_VERIFICATION_DATE AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
82: NAME_CONTROL AP_SUPPLIERS.NAME_CONTROL%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
83: STATE_REPORTABLE_FLAG AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
84: FEDERAL_REPORTABLE_FLAG AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
85: ATTRIBUTE_CATEGORY AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
86: ATTRIBUTE1 AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
87: ATTRIBUTE2 AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
88: ATTRIBUTE3 AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
89: ATTRIBUTE4 AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
90: ATTRIBUTE5 AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
91: ATTRIBUTE6 AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
92: ATTRIBUTE7 AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
93: ATTRIBUTE8 AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
94: ATTRIBUTE9 AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102: VALIDATION_NUMBER NUMBER,
95: ATTRIBUTE10 AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102: VALIDATION_NUMBER NUMBER,
103: EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
96: ATTRIBUTE11 AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102: VALIDATION_NUMBER NUMBER,
103: EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
104: TAX_REPORTING_NAME AP_SUPPLIERS.TAX_REPORTING_NAME%TYPE,
97: ATTRIBUTE12 AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98: ATTRIBUTE13 AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102: VALIDATION_NUMBER NUMBER,
103: EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
104: TAX_REPORTING_NAME AP_SUPPLIERS.TAX_REPORTING_NAME%TYPE,
105: CHECK_DIGITS AP_SUPPLIERS.CHECK_DIGITS%TYPE,
99: ATTRIBUTE14 AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102: VALIDATION_NUMBER NUMBER,
103: EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
104: TAX_REPORTING_NAME AP_SUPPLIERS.TAX_REPORTING_NAME%TYPE,
105: CHECK_DIGITS AP_SUPPLIERS.CHECK_DIGITS%TYPE,
106: ALLOW_AWT_FLAG AP_SUPPLIERS.ALLOW_AWT_FLAG%TYPE,
107: AWT_GROUP_ID NUMBER,
100: ATTRIBUTE15 AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102: VALIDATION_NUMBER NUMBER,
103: EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
104: TAX_REPORTING_NAME AP_SUPPLIERS.TAX_REPORTING_NAME%TYPE,
105: CHECK_DIGITS AP_SUPPLIERS.CHECK_DIGITS%TYPE,
106: ALLOW_AWT_FLAG AP_SUPPLIERS.ALLOW_AWT_FLAG%TYPE,
107: AWT_GROUP_ID NUMBER,
108: AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,
101: AUTO_CALCULATE_INTEREST_FLAG AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102: VALIDATION_NUMBER NUMBER,
103: EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
104: TAX_REPORTING_NAME AP_SUPPLIERS.TAX_REPORTING_NAME%TYPE,
105: CHECK_DIGITS AP_SUPPLIERS.CHECK_DIGITS%TYPE,
106: ALLOW_AWT_FLAG AP_SUPPLIERS.ALLOW_AWT_FLAG%TYPE,
107: AWT_GROUP_ID NUMBER,
108: AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,
109: PAY_AWT_GROUP_ID NUMBER, --bug6664407
102: VALIDATION_NUMBER NUMBER,
103: EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
104: TAX_REPORTING_NAME AP_SUPPLIERS.TAX_REPORTING_NAME%TYPE,
105: CHECK_DIGITS AP_SUPPLIERS.CHECK_DIGITS%TYPE,
106: ALLOW_AWT_FLAG AP_SUPPLIERS.ALLOW_AWT_FLAG%TYPE,
107: AWT_GROUP_ID NUMBER,
108: AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,
109: PAY_AWT_GROUP_ID NUMBER, --bug6664407
110: PAY_AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,--bug6664407
107: AWT_GROUP_ID NUMBER,
108: AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,
109: PAY_AWT_GROUP_ID NUMBER, --bug6664407
110: PAY_AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,--bug6664407
111: GLOBAL_ATTRIBUTE1 AP_SUPPLIERS.GLOBAL_ATTRIBUTE1%TYPE,
112: GLOBAL_ATTRIBUTE2 AP_SUPPLIERS.GLOBAL_ATTRIBUTE2%TYPE,
113: GLOBAL_ATTRIBUTE3 AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
108: AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,
109: PAY_AWT_GROUP_ID NUMBER, --bug6664407
110: PAY_AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,--bug6664407
111: GLOBAL_ATTRIBUTE1 AP_SUPPLIERS.GLOBAL_ATTRIBUTE1%TYPE,
112: GLOBAL_ATTRIBUTE2 AP_SUPPLIERS.GLOBAL_ATTRIBUTE2%TYPE,
113: GLOBAL_ATTRIBUTE3 AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
109: PAY_AWT_GROUP_ID NUMBER, --bug6664407
110: PAY_AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,--bug6664407
111: GLOBAL_ATTRIBUTE1 AP_SUPPLIERS.GLOBAL_ATTRIBUTE1%TYPE,
112: GLOBAL_ATTRIBUTE2 AP_SUPPLIERS.GLOBAL_ATTRIBUTE2%TYPE,
113: GLOBAL_ATTRIBUTE3 AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
110: PAY_AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,--bug6664407
111: GLOBAL_ATTRIBUTE1 AP_SUPPLIERS.GLOBAL_ATTRIBUTE1%TYPE,
112: GLOBAL_ATTRIBUTE2 AP_SUPPLIERS.GLOBAL_ATTRIBUTE2%TYPE,
113: GLOBAL_ATTRIBUTE3 AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
111: GLOBAL_ATTRIBUTE1 AP_SUPPLIERS.GLOBAL_ATTRIBUTE1%TYPE,
112: GLOBAL_ATTRIBUTE2 AP_SUPPLIERS.GLOBAL_ATTRIBUTE2%TYPE,
113: GLOBAL_ATTRIBUTE3 AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
112: GLOBAL_ATTRIBUTE2 AP_SUPPLIERS.GLOBAL_ATTRIBUTE2%TYPE,
113: GLOBAL_ATTRIBUTE3 AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
113: GLOBAL_ATTRIBUTE3 AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
114: GLOBAL_ATTRIBUTE4 AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
115: GLOBAL_ATTRIBUTE5 AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
116: GLOBAL_ATTRIBUTE6 AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
117: GLOBAL_ATTRIBUTE7 AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
118: GLOBAL_ATTRIBUTE8 AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
119: GLOBAL_ATTRIBUTE9 AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
120: GLOBAL_ATTRIBUTE10 AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
121: GLOBAL_ATTRIBUTE11 AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
122: GLOBAL_ATTRIBUTE12 AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
123: GLOBAL_ATTRIBUTE13 AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
124: GLOBAL_ATTRIBUTE14 AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132: BANK_CHARGE_BEARER AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
125: GLOBAL_ATTRIBUTE15 AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132: BANK_CHARGE_BEARER AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
133: MATCH_OPTION AP_SUPPLIERS.MATCH_OPTION%TYPE,
126: GLOBAL_ATTRIBUTE16 AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132: BANK_CHARGE_BEARER AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
133: MATCH_OPTION AP_SUPPLIERS.MATCH_OPTION%TYPE,
134: CREATE_DEBIT_MEMO_FLAG AP_SUPPLIERS.CREATE_DEBIT_MEMO_FLAG%TYPE,
127: GLOBAL_ATTRIBUTE17 AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132: BANK_CHARGE_BEARER AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
133: MATCH_OPTION AP_SUPPLIERS.MATCH_OPTION%TYPE,
134: CREATE_DEBIT_MEMO_FLAG AP_SUPPLIERS.CREATE_DEBIT_MEMO_FLAG%TYPE,
135: PARTY_ID NUMBER,
128: GLOBAL_ATTRIBUTE18 AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132: BANK_CHARGE_BEARER AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
133: MATCH_OPTION AP_SUPPLIERS.MATCH_OPTION%TYPE,
134: CREATE_DEBIT_MEMO_FLAG AP_SUPPLIERS.CREATE_DEBIT_MEMO_FLAG%TYPE,
135: PARTY_ID NUMBER,
136: PARENT_PARTY_ID NUMBER,
129: GLOBAL_ATTRIBUTE19 AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132: BANK_CHARGE_BEARER AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
133: MATCH_OPTION AP_SUPPLIERS.MATCH_OPTION%TYPE,
134: CREATE_DEBIT_MEMO_FLAG AP_SUPPLIERS.CREATE_DEBIT_MEMO_FLAG%TYPE,
135: PARTY_ID NUMBER,
136: PARENT_PARTY_ID NUMBER,
137: JGZZ_FISCAL_CODE VARCHAR2(20),
130: GLOBAL_ATTRIBUTE20 AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131: GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132: BANK_CHARGE_BEARER AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
133: MATCH_OPTION AP_SUPPLIERS.MATCH_OPTION%TYPE,
134: CREATE_DEBIT_MEMO_FLAG AP_SUPPLIERS.CREATE_DEBIT_MEMO_FLAG%TYPE,
135: PARTY_ID NUMBER,
136: PARENT_PARTY_ID NUMBER,
137: JGZZ_FISCAL_CODE VARCHAR2(20),
138: SIC_CODE VARCHAR2(30),
140: INVENTORY_ORGANIZATION_ID NUMBER,
141: TERMS_NAME AP_TERMS_TL.NAME%TYPE,
142: DEFAULT_TERMS_ID NUMBER,
143: VENDOR_INTERFACE_ID NUMBER,
144: NI_NUMBER AP_SUPPLIERS.NI_NUMBER%TYPE,
145: EXT_PAYEE_REC IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE,
146: -- Bug 7437549 Start
147: EDI_PAYMENT_FORMAT AP_SUPPLIERS_INT.EDI_PAYMENT_FORMAT%TYPE,
148: EDI_TRANSACTION_HANDLING AP_SUPPLIERS_INT.EDI_TRANSACTION_HANDLING%TYPE,
143: VENDOR_INTERFACE_ID NUMBER,
144: NI_NUMBER AP_SUPPLIERS.NI_NUMBER%TYPE,
145: EXT_PAYEE_REC IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE,
146: -- Bug 7437549 Start
147: EDI_PAYMENT_FORMAT AP_SUPPLIERS_INT.EDI_PAYMENT_FORMAT%TYPE,
148: EDI_TRANSACTION_HANDLING AP_SUPPLIERS_INT.EDI_TRANSACTION_HANDLING%TYPE,
149: EDI_PAYMENT_METHOD AP_SUPPLIERS_INT.EDI_PAYMENT_METHOD%TYPE,
150: EDI_REMITTANCE_METHOD AP_SUPPLIERS_INT.EDI_REMITTANCE_METHOD%TYPE,
151: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIERS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE
144: NI_NUMBER AP_SUPPLIERS.NI_NUMBER%TYPE,
145: EXT_PAYEE_REC IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE,
146: -- Bug 7437549 Start
147: EDI_PAYMENT_FORMAT AP_SUPPLIERS_INT.EDI_PAYMENT_FORMAT%TYPE,
148: EDI_TRANSACTION_HANDLING AP_SUPPLIERS_INT.EDI_TRANSACTION_HANDLING%TYPE,
149: EDI_PAYMENT_METHOD AP_SUPPLIERS_INT.EDI_PAYMENT_METHOD%TYPE,
150: EDI_REMITTANCE_METHOD AP_SUPPLIERS_INT.EDI_REMITTANCE_METHOD%TYPE,
151: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIERS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE
152: -- Bug 7437549 End
145: EXT_PAYEE_REC IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE,
146: -- Bug 7437549 Start
147: EDI_PAYMENT_FORMAT AP_SUPPLIERS_INT.EDI_PAYMENT_FORMAT%TYPE,
148: EDI_TRANSACTION_HANDLING AP_SUPPLIERS_INT.EDI_TRANSACTION_HANDLING%TYPE,
149: EDI_PAYMENT_METHOD AP_SUPPLIERS_INT.EDI_PAYMENT_METHOD%TYPE,
150: EDI_REMITTANCE_METHOD AP_SUPPLIERS_INT.EDI_REMITTANCE_METHOD%TYPE,
151: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIERS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE
152: -- Bug 7437549 End
153: );
146: -- Bug 7437549 Start
147: EDI_PAYMENT_FORMAT AP_SUPPLIERS_INT.EDI_PAYMENT_FORMAT%TYPE,
148: EDI_TRANSACTION_HANDLING AP_SUPPLIERS_INT.EDI_TRANSACTION_HANDLING%TYPE,
149: EDI_PAYMENT_METHOD AP_SUPPLIERS_INT.EDI_PAYMENT_METHOD%TYPE,
150: EDI_REMITTANCE_METHOD AP_SUPPLIERS_INT.EDI_REMITTANCE_METHOD%TYPE,
151: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIERS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE
152: -- Bug 7437549 End
153: );
154:
147: EDI_PAYMENT_FORMAT AP_SUPPLIERS_INT.EDI_PAYMENT_FORMAT%TYPE,
148: EDI_TRANSACTION_HANDLING AP_SUPPLIERS_INT.EDI_TRANSACTION_HANDLING%TYPE,
149: EDI_PAYMENT_METHOD AP_SUPPLIERS_INT.EDI_PAYMENT_METHOD%TYPE,
150: EDI_REMITTANCE_METHOD AP_SUPPLIERS_INT.EDI_REMITTANCE_METHOD%TYPE,
151: EDI_REMITTANCE_INSTRUCTION AP_SUPPLIERS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE
152: -- Bug 7437549 End
153: );
154:
155: TYPE r_vendor_site_rec_type IS RECORD(
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: p_vendor_rec IN r_vendor_rec_type,
426: x_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE,
427: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE
428: );
429:
430: -- Start of comments
862: --
863: -- Notes : Import Vendors,
864: -- called from Import Vendor Concurrent Program
865: -- This will call vendor APIS to
866: -- create vendors based on AP_SUPPLIERS_INT
867: --
868: -- End of comments
869:
870: PROCEDURE Import_Vendors