DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PARAMS dependencies on PO_SYSTEM_PARAMETERS

Line 17: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,

13: bill_to_location_id FINANCIALS_SYSTEM_PARAMETERS.bill_to_location_id%TYPE,
14: fob_lookup_code FINANCIALS_SYSTEM_PARAMETERS.fob_lookup_code%TYPE,
15: freight_terms_lookup_code FINANCIALS_SYSTEM_PARAMETERS.freight_terms_lookup_code%TYPE,
16: terms_id FINANCIALS_SYSTEM_PARAMETERS.terms_id%TYPE,
17: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
18: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
19: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
20: enforce_buyer_name_flag varchar2(1),
21: enforce_buyer_auth_flag varchar2(1),

Line 18: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,

14: fob_lookup_code FINANCIALS_SYSTEM_PARAMETERS.fob_lookup_code%TYPE,
15: freight_terms_lookup_code FINANCIALS_SYSTEM_PARAMETERS.freight_terms_lookup_code%TYPE,
16: terms_id FINANCIALS_SYSTEM_PARAMETERS.terms_id%TYPE,
17: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
18: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
19: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
20: enforce_buyer_name_flag varchar2(1),
21: enforce_buyer_auth_flag varchar2(1),
22: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,

Line 19: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,

15: freight_terms_lookup_code FINANCIALS_SYSTEM_PARAMETERS.freight_terms_lookup_code%TYPE,
16: terms_id FINANCIALS_SYSTEM_PARAMETERS.terms_id%TYPE,
17: default_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE,
18: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
19: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
20: enforce_buyer_name_flag varchar2(1),
21: enforce_buyer_auth_flag varchar2(1),
22: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
23: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,

Line 22: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,

18: taxable_flag PO_SYSTEM_PARAMETERS.taxable_flag%TYPE,
19: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
20: enforce_buyer_name_flag varchar2(1),
21: enforce_buyer_auth_flag varchar2(1),
22: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
23: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
24: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
25: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
26: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,

Line 23: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,

19: receiving_flag PO_SYSTEM_PARAMETERS.receiving_flag%TYPE,
20: enforce_buyer_name_flag varchar2(1),
21: enforce_buyer_auth_flag varchar2(1),
22: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
23: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
24: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
25: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
26: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
27: rev_sort_ordering NUMBER ,

Line 24: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,

20: enforce_buyer_name_flag varchar2(1),
21: enforce_buyer_auth_flag varchar2(1),
22: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
23: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
24: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
25: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
26: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
27: rev_sort_ordering NUMBER ,
28: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,

Line 25: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,

21: enforce_buyer_auth_flag varchar2(1),
22: line_type_id PO_SYSTEM_PARAMETERS.line_type_id%TYPE,
23: manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE,
24: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
25: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
26: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
27: rev_sort_ordering NUMBER ,
28: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
29: notify_blanket_flag varchar2(1),

Line 28: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,

24: user_defined_po_num_code PO_SYSTEM_PARAMETERS.user_defined_po_num_code%TYPE,
25: price_type_lookup_code PO_SYSTEM_PARAMETERS.price_type_lookup_code%TYPE,
26: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
27: rev_sort_ordering NUMBER ,
28: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
29: notify_blanket_flag varchar2(1),
30: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
31: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
32: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,

Line 30: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,

26: def_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE,
27: rev_sort_ordering NUMBER ,
28: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
29: notify_blanket_flag varchar2(1),
30: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
31: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
32: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
33: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
34: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,

Line 31: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,

27: rev_sort_ordering NUMBER ,
28: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
29: notify_blanket_flag varchar2(1),
30: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
31: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
32: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
33: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
34: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
35: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,

Line 32: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,

28: min_rel_amount PO_SYSTEM_PARAMETERS.min_release_amount%TYPE,
29: notify_blanket_flag varchar2(1),
30: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
31: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
32: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
33: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
34: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
35: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
36: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,

Line 33: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,

29: notify_blanket_flag varchar2(1),
30: def_quote_warning_delay PO_SYSTEM_PARAMETERS.default_quote_warning_delay%TYPE,
31: inspection_required_flag PO_SYSTEM_PARAMETERS.inspection_required_flag%TYPE,
32: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
33: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
34: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
35: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
36: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
37: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,

Line 36: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,

32: user_defined_quote_num_code PO_SYSTEM_PARAMETERS.user_defined_quote_num_code%TYPE,
33: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
34: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
35: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
36: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
37: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
38: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
39: security_structure_id number,
40: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,

Line 37: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,

33: manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE,
34: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
35: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
36: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
37: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
38: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
39: security_structure_id number,
40: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,
41: master_inv_org_id MTL_PARAMETERS.organization_id%TYPE,

Line 38: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,

34: ship_via_lookup_code FINANCIALS_SYSTEM_PARAMETERS.ship_via_lookup_code%TYPE,
35: qty_rcv_tolerance RCV_PARAMETERS.qty_rcv_tolerance%TYPE,
36: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
37: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
38: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
39: security_structure_id number,
40: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,
41: master_inv_org_id MTL_PARAMETERS.organization_id%TYPE,
42: enforce_ship_to_loc RCV_PARAMETERS.enforce_ship_to_location_code%TYPE,

Line 40: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,

36: price_break_lookup_code PO_SYSTEM_PARAMETERS.price_break_lookup_code%TYPE,
37: invoice_close_tolerance PO_SYSTEM_PARAMETERS.invoice_close_tolerance%TYPE,
38: receive_close_tolerance PO_SYSTEM_PARAMETERS.receive_close_tolerance%TYPE,
39: security_structure_id number,
40: expense_accrual_code PO_SYSTEM_PARAMETERS.expense_accrual_code%TYPE,
41: master_inv_org_id MTL_PARAMETERS.organization_id%TYPE,
42: enforce_ship_to_loc RCV_PARAMETERS.enforce_ship_to_location_code%TYPE,
43: allow_substitutes RCV_PARAMETERS.allow_substitute_receipts_flag%TYPE,
44: routing_id RCV_PARAMETERS.receiving_routing_id%TYPE,

Line 49: supplier_auth_acc PO_SYSTEM_PARAMETERS.supplier_authoring_acceptance%TYPE,

45: qty_rcv_exception RCV_PARAMETERS.qty_rcv_exception_code%TYPE,
46: days_early_receipt RCV_PARAMETERS.days_early_receipt_allowed%TYPE,
47: days_late_receipt RCV_PARAMETERS.days_late_receipt_allowed%TYPE,
48: rcv_days_exception RCV_PARAMETERS.receipt_days_exception_code%TYPE,
49: supplier_auth_acc PO_SYSTEM_PARAMETERS.supplier_authoring_acceptance%TYPE,
50: cat_admin_auth_acc PO_SYSTEM_PARAMETERS.cat_admin_authoring_acceptance%TYPE,
51: invoice_match_option FINANCIALS_SYSTEM_PARAMETERS.match_option%TYPE,
52: when_to_archive_blanket PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,
53: when_to_archive_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,

Line 50: cat_admin_auth_acc PO_SYSTEM_PARAMETERS.cat_admin_authoring_acceptance%TYPE,

46: days_early_receipt RCV_PARAMETERS.days_early_receipt_allowed%TYPE,
47: days_late_receipt RCV_PARAMETERS.days_late_receipt_allowed%TYPE,
48: rcv_days_exception RCV_PARAMETERS.receipt_days_exception_code%TYPE,
49: supplier_auth_acc PO_SYSTEM_PARAMETERS.supplier_authoring_acceptance%TYPE,
50: cat_admin_auth_acc PO_SYSTEM_PARAMETERS.cat_admin_authoring_acceptance%TYPE,
51: invoice_match_option FINANCIALS_SYSTEM_PARAMETERS.match_option%TYPE,
52: when_to_archive_blanket PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,
53: when_to_archive_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE,
54: def_business_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE,

Line 58: acceptance_required_flag PO_SYSTEM_PARAMETERS.acceptance_required_flag%TYPE, /* Bug 7518967 : Default Acceptance Required Check ER */

54: def_business_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE,
55: def_structure_id MTL_CATEGORY_SETS.structure_id%TYPE,
56: def_cat_set_id MTL_CATEGORY_SETS.category_set_id%TYPE,
57: def_category_id MTL_CATEGORY_SETS.default_category_id%TYPE,
58: acceptance_required_flag PO_SYSTEM_PARAMETERS.acceptance_required_flag%TYPE, /* Bug 7518967 : Default Acceptance Required Check ER */
59: budgetary_control_flag varchar2(1),
60: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,
61: rfq_required_flag varchar2(1),
62: manual_req_num_type po_system_parameters.manual_req_num_type%type,

Line 60: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,

56: def_cat_set_id MTL_CATEGORY_SETS.category_set_id%TYPE,
57: def_category_id MTL_CATEGORY_SETS.default_category_id%TYPE,
58: acceptance_required_flag PO_SYSTEM_PARAMETERS.acceptance_required_flag%TYPE, /* Bug 7518967 : Default Acceptance Required Check ER */
59: budgetary_control_flag varchar2(1),
60: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,
61: rfq_required_flag varchar2(1),
62: manual_req_num_type po_system_parameters.manual_req_num_type%type,
63: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
64: disposition_warning_flag varchar2(1),

Line 62: manual_req_num_type po_system_parameters.manual_req_num_type%type,

58: acceptance_required_flag PO_SYSTEM_PARAMETERS.acceptance_required_flag%TYPE, /* Bug 7518967 : Default Acceptance Required Check ER */
59: budgetary_control_flag varchar2(1),
60: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,
61: rfq_required_flag varchar2(1),
62: manual_req_num_type po_system_parameters.manual_req_num_type%type,
63: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
64: disposition_warning_flag varchar2(1),
65: reserve_at_completion_flag varchar2(1),
66: user_defined_rcpt_num_code po_system_parameters.user_defined_receipt_num_code%type,

Line 63: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,

59: budgetary_control_flag varchar2(1),
60: user_defined_req_num_code po_system_parameters.user_defined_req_num_code%type,
61: rfq_required_flag varchar2(1),
62: manual_req_num_type po_system_parameters.manual_req_num_type%type,
63: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
64: disposition_warning_flag varchar2(1),
65: reserve_at_completion_flag varchar2(1),
66: user_defined_rcpt_num_code po_system_parameters.user_defined_receipt_num_code%type,
67: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,

Line 66: user_defined_rcpt_num_code po_system_parameters.user_defined_receipt_num_code%type,

62: manual_req_num_type po_system_parameters.manual_req_num_type%type,
63: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
64: disposition_warning_flag varchar2(1),
65: reserve_at_completion_flag varchar2(1),
66: user_defined_rcpt_num_code po_system_parameters.user_defined_receipt_num_code%type,
67: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,
68: use_positions_flag varchar2(1),
69: default_quote_warning_delay number,
70: user_defined_rfq_num_code po_system_parameters.user_defined_rfq_num_code%type,

Line 67: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,

63: enforce_full_lot_qty po_system_parameters.enforce_full_lot_quantities%type,
64: disposition_warning_flag varchar2(1),
65: reserve_at_completion_flag varchar2(1),
66: user_defined_rcpt_num_code po_system_parameters.user_defined_receipt_num_code%type,
67: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,
68: use_positions_flag varchar2(1),
69: default_quote_warning_delay number,
70: user_defined_rfq_num_code po_system_parameters.user_defined_rfq_num_code%type,
71: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,

Line 70: user_defined_rfq_num_code po_system_parameters.user_defined_rfq_num_code%type,

66: user_defined_rcpt_num_code po_system_parameters.user_defined_receipt_num_code%type,
67: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,
68: use_positions_flag varchar2(1),
69: default_quote_warning_delay number,
70: user_defined_rfq_num_code po_system_parameters.user_defined_rfq_num_code%type,
71: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,
72: period_name gl_period_statuses.period_name%type
73: );
74:

Line 71: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,

67: manual_rcpt_num_type po_system_parameters.manual_receipt_num_type%type,
68: use_positions_flag varchar2(1),
69: default_quote_warning_delay number,
70: user_defined_rfq_num_code po_system_parameters.user_defined_rfq_num_code%type,
71: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,
72: period_name gl_period_statuses.period_name%type
73: );
74:
75: -- Record type to store profile options