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.ARP_PROCESS_FREIGHT_UTIL dependencies on RA_CUSTOMER_TRX

Line 57: p_ct_id IN ra_customer_trx.customer_trx_id%type,

53:
54: PROCEDURE default_freight_line(
55: p_form_name IN varchar2,
56: p_form_version IN number,
57: p_ct_id IN ra_customer_trx.customer_trx_id%type,
58: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,

Line 58: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,

54: PROCEDURE default_freight_line(
55: p_form_name IN varchar2,
56: p_form_version IN number,
57: p_ct_id IN ra_customer_trx.customer_trx_id%type,
58: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,

Line 59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,

55: p_form_name IN varchar2,
56: p_form_version IN number,
57: p_ct_id IN ra_customer_trx.customer_trx_id%type,
58: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,

Line 60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,

56: p_form_version IN number,
57: p_ct_id IN ra_customer_trx.customer_trx_id%type,
58: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
64: p_currency_code IN fnd_currencies.currency_code%type,

Line 61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,

57: p_ct_id IN ra_customer_trx.customer_trx_id%type,
58: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
64: p_currency_code IN fnd_currencies.currency_code%type,
65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,

Line 62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,

58: p_line_ctl_id IN ra_customer_trx_lines.customer_trx_line_id%type,
59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
64: p_currency_code IN fnd_currencies.currency_code%type,
65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,

Line 63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,

59: p_prev_ct_id IN ra_customer_trx.customer_trx_id%type,
60: p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
64: p_currency_code IN fnd_currencies.currency_code%type,
65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,

61: p_primary_salesrep_id IN ra_customer_trx.cust_trx_type_id%type,
62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
64: p_currency_code IN fnd_currencies.currency_code%type,
65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,

Line 66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,

62: p_inventory_item_id IN ra_customer_trx_lines.inventory_item_id%type,
63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
64: p_currency_code IN fnd_currencies.currency_code%type,
65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,
70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

63: p_memo_line_id IN ra_customer_trx_lines.memo_line_id%type,
64: p_currency_code IN fnd_currencies.currency_code%type,
65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,
70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
71: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

Line 68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,

64: p_currency_code IN fnd_currencies.currency_code%type,
65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,
70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
71: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
72: p_ccid OUT NOCOPY ra_cust_trx_line_gl_dist.code_combination_id%type,

Line 69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,

65: p_line_prev_ctl_id IN OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,
70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
71: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
72: p_ccid OUT NOCOPY ra_cust_trx_line_gl_dist.code_combination_id%type,
73: p_concat_segments OUT NOCOPY ra_cust_trx_line_gl_dist.concatenated_segments%type,

Line 70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

66: p_prev_ctl_id OUT NOCOPY ra_customer_trx_lines.customer_trx_line_id%type,
67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,
70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
71: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
72: p_ccid OUT NOCOPY ra_cust_trx_line_gl_dist.code_combination_id%type,
73: p_concat_segments OUT NOCOPY ra_cust_trx_line_gl_dist.concatenated_segments%type,
74: p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%type)

Line 71: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,

67: p_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
68: p_inv_line_number OUT NOCOPY ra_customer_trx_lines.line_number%type,
69: p_inv_frt_ccid OUT NOCOPY ra_customer_trx_lines.line_number%type,
70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
71: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
72: p_ccid OUT NOCOPY ra_cust_trx_line_gl_dist.code_combination_id%type,
73: p_concat_segments OUT NOCOPY ra_cust_trx_line_gl_dist.concatenated_segments%type,
74: p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%type)
75: IS

Line 74: p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%type)

70: p_inv_frt_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
71: p_inv_frt_uncr_amount OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
72: p_ccid OUT NOCOPY ra_cust_trx_line_gl_dist.code_combination_id%type,
73: p_concat_segments OUT NOCOPY ra_cust_trx_line_gl_dist.concatenated_segments%type,
74: p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%type)
75: IS
76: l_inv_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
77: l_inv_frt_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
78: l_inv_frt_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;

Line 76: l_inv_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

72: p_ccid OUT NOCOPY ra_cust_trx_line_gl_dist.code_combination_id%type,
73: p_concat_segments OUT NOCOPY ra_cust_trx_line_gl_dist.concatenated_segments%type,
74: p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%type)
75: IS
76: l_inv_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
77: l_inv_frt_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
78: l_inv_frt_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
80: l_inv_line_number ra_customer_trx_lines.line_number%type;

Line 77: l_inv_frt_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

73: p_concat_segments OUT NOCOPY ra_cust_trx_line_gl_dist.concatenated_segments%type,
74: p_ussgl_code OUT NOCOPY ra_customer_trx.default_ussgl_transaction_code%type)
75: IS
76: l_inv_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
77: l_inv_frt_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
78: l_inv_frt_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
80: l_inv_line_number ra_customer_trx_lines.line_number%type;
81: l_amount ra_customer_trx_lines.extended_amount%type;

Line 79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

75: IS
76: l_inv_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
77: l_inv_frt_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
78: l_inv_frt_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
80: l_inv_line_number ra_customer_trx_lines.line_number%type;
81: l_amount ra_customer_trx_lines.extended_amount%type;
82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;

Line 80: l_inv_line_number ra_customer_trx_lines.line_number%type;

76: l_inv_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
77: l_inv_frt_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
78: l_inv_frt_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
80: l_inv_line_number ra_customer_trx_lines.line_number%type;
81: l_amount ra_customer_trx_lines.extended_amount%type;
82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;
84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;

Line 81: l_amount ra_customer_trx_lines.extended_amount%type;

77: l_inv_frt_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
78: l_inv_frt_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
80: l_inv_line_number ra_customer_trx_lines.line_number%type;
81: l_amount ra_customer_trx_lines.extended_amount%type;
82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;
84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;
85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;

Line 82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;

78: l_inv_frt_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
80: l_inv_line_number ra_customer_trx_lines.line_number%type;
81: l_amount ra_customer_trx_lines.extended_amount%type;
82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;
84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;
85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;
86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';

Line 83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;

79: l_inv_prev_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
80: l_inv_line_number ra_customer_trx_lines.line_number%type;
81: l_amount ra_customer_trx_lines.extended_amount%type;
82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;
84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;
85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;
86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';
87:

Line 84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;

80: l_inv_line_number ra_customer_trx_lines.line_number%type;
81: l_amount ra_customer_trx_lines.extended_amount%type;
82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;
84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;
85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;
86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';
87:
88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;

Line 85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;

81: l_amount ra_customer_trx_lines.extended_amount%type;
82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;
84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;
85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;
86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';
87:
88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;
89: l_line_extended_amount ra_customer_trx_lines.extended_amount%type;

Line 86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';

82: l_line_ussgl_code ra_customer_trx_lines.default_ussgl_transaction_code%type;
83: l_header_ussgl_code ra_customer_trx.default_ussgl_transaction_code%type;
84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;
85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;
86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';
87:
88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;
89: l_line_extended_amount ra_customer_trx_lines.extended_amount%type;
90: l_inv_frt_amount ra_customer_trx_lines.extended_amount%type;

Line 88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;

84: l_inventory_item_id ra_customer_trx_lines.inventory_item_id%type := p_inventory_item_id;
85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;
86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';
87:
88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;
89: l_line_extended_amount ra_customer_trx_lines.extended_amount%type;
90: l_inv_frt_amount ra_customer_trx_lines.extended_amount%type;
91: l_inv_frt_uncr_amount ra_customer_trx_lines.extended_amount%type;
92:

Line 89: l_line_extended_amount ra_customer_trx_lines.extended_amount%type;

85: l_memo_line_id ra_customer_trx_lines.memo_line_id%type := p_memo_line_id;
86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';
87:
88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;
89: l_line_extended_amount ra_customer_trx_lines.extended_amount%type;
90: l_inv_frt_amount ra_customer_trx_lines.extended_amount%type;
91: l_inv_frt_uncr_amount ra_customer_trx_lines.extended_amount%type;
92:
93: l_ccid number;

Line 90: l_inv_frt_amount ra_customer_trx_lines.extended_amount%type;

86: l_warehouse_id ra_customer_trx_lines.warehouse_id%type := '';
87:
88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;
89: l_line_extended_amount ra_customer_trx_lines.extended_amount%type;
90: l_inv_frt_amount ra_customer_trx_lines.extended_amount%type;
91: l_inv_frt_uncr_amount ra_customer_trx_lines.extended_amount%type;
92:
93: l_ccid number;
94: l_num_failed_rows number;

Line 91: l_inv_frt_uncr_amount ra_customer_trx_lines.extended_amount%type;

87:
88: l_inv_line_extended_amount ra_customer_trx_lines.extended_amount%type;
89: l_line_extended_amount ra_customer_trx_lines.extended_amount%type;
90: l_inv_frt_amount ra_customer_trx_lines.extended_amount%type;
91: l_inv_frt_uncr_amount ra_customer_trx_lines.extended_amount%type;
92:
93: l_ccid number;
94: l_num_failed_rows number;
95: l_result number;

Line 123: FROM ra_customer_trx_lines

119: l_inventory_item_id,
120: l_memo_line_id,
121: l_line_extended_amount,
122: l_line_ussgl_code
123: FROM ra_customer_trx_lines
124: WHERE customer_trx_id = p_ct_id
125: AND customer_trx_line_id = p_line_ctl_id;
126: ELSE
127: l_inv_prev_ctl_id := p_line_prev_ctl_id;

Line 149: FROM RA_CUSTOMER_TRX_LINES_FRT_V ctl_inv

145: l_inv_frt_ctl_id,
146: l_inv_frt_ccid,
147: l_inv_frt_amount,
148: l_inv_frt_uncr_amount
149: FROM RA_CUSTOMER_TRX_LINES_FRT_V ctl_inv
150: WHERE ctl_inv.customer_trx_id = p_prev_ct_id
151: AND nvl(ctl_inv.link_to_cust_trx_line_id, -10)
152: = nvl(l_inv_prev_ctl_id, -10);
153:

Line 160: from ra_customer_trx_lines ctl

156: IF (l_inv_prev_ctl_id IS NOT NULL) THEN
157: --points to the line credited so get the warehouse id
158: select ctl.warehouse_id
159: into l_warehouse_id
160: from ra_customer_trx_lines ctl
161: where ctl.customer_trx_line_id = l_inv_prev_ctl_id;
162: END IF;
163:
164: IF (p_line_prev_ctl_id IS NULL)

Line 290: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) RETURN varchar2

286: +===========================================================================*/
287:
288:
289: FUNCTION get_freight_type(
290: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) RETURN varchar2
291: IS
292: l_frt_type varchar2(1);
293: BEGIN
294:

Line 305: FROM ra_customer_trx_lines ctl

301: decode(max(link_to_cust_trx_line_id),
302: null, 'H',
303: 'L'))
304: INTO l_frt_type
305: FROM ra_customer_trx_lines ctl
306: WHERE ctl.customer_trx_id = p_customer_trx_id
307: AND ctl.line_type = 'FREIGHT';
308:
309: return(l_frt_type);

Line 363: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)

359: p_form_version IN number,
360: p_trx_class IN ra_cust_trx_types.type%type,
361: p_complete_flag IN varchar2,
362: p_open_rec_flag IN varchar2,
363: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
364: IS
365:
366: CURSOR frt_lines(p_ct_id ra_customer_trx.customer_trx_id%type) IS
367: SELECT customer_trx_line_id

Line 366: CURSOR frt_lines(p_ct_id ra_customer_trx.customer_trx_id%type) IS

362: p_open_rec_flag IN varchar2,
363: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type)
364: IS
365:
366: CURSOR frt_lines(p_ct_id ra_customer_trx.customer_trx_id%type) IS
367: SELECT customer_trx_line_id
368: FROM ra_customer_trx_lines
369: WHERE customer_trx_id = p_ct_id
370: AND line_type = 'FREIGHT';

Line 368: FROM ra_customer_trx_lines

364: IS
365:
366: CURSOR frt_lines(p_ct_id ra_customer_trx.customer_trx_id%type) IS
367: SELECT customer_trx_line_id
368: FROM ra_customer_trx_lines
369: WHERE customer_trx_id = p_ct_id
370: AND line_type = 'FREIGHT';
371:
372: BEGIN