APPS.JL_ZZ_INVOICE_CREATE dependencies on AR_TRX_LINES_GT

Line 45: SELECT ar_trx_lines_gt.trx_line_id

41: l_index binary_integer;
42:
43:
44: CURSOR trx_lines_cursor (c_request_id NUMBER) IS
45: SELECT ar_trx_lines_gt.trx_line_id
46: , ar_trx_header_gt.cust_trx_type_id trx_type
47: , ar_trx_header_gt.trx_date
48: , nvl(ship_to_address_id , bill_to_address_id)
49: ship_to_address_id

Line 50: , ar_trx_lines_gt.line_type

46: , ar_trx_header_gt.cust_trx_type_id trx_type
47: , ar_trx_header_gt.trx_date
48: , nvl(ship_to_address_id , bill_to_address_id)
49: ship_to_address_id
50: , ar_trx_lines_gt.line_type
51: , ar_trx_lines_gt.memo_line_id
52: , ar_trx_lines_gt.inventory_item_id
53: , ar_trx_header_gt.global_attribute1
54: , ar_trx_header_gt.global_attribute2

Line 51: , ar_trx_lines_gt.memo_line_id

47: , ar_trx_header_gt.trx_date
48: , nvl(ship_to_address_id , bill_to_address_id)
49: ship_to_address_id
50: , ar_trx_lines_gt.line_type
51: , ar_trx_lines_gt.memo_line_id
52: , ar_trx_lines_gt.inventory_item_id
53: , ar_trx_header_gt.global_attribute1
54: , ar_trx_header_gt.global_attribute2
55: , ar_trx_header_gt.global_attribute3

Line 52: , ar_trx_lines_gt.inventory_item_id

48: , nvl(ship_to_address_id , bill_to_address_id)
49: ship_to_address_id
50: , ar_trx_lines_gt.line_type
51: , ar_trx_lines_gt.memo_line_id
52: , ar_trx_lines_gt.inventory_item_id
53: , ar_trx_header_gt.global_attribute1
54: , ar_trx_header_gt.global_attribute2
55: , ar_trx_header_gt.global_attribute3
56: , ar_trx_header_gt.global_attribute4

Line 70: , ar_trx_lines_gt.global_attribute1

66: , ar_trx_header_gt.global_attribute14
67: , ar_trx_header_gt.global_attribute15
68: , ar_trx_header_gt.global_attribute16
69: , ar_trx_header_gt.global_attribute17
70: , ar_trx_lines_gt.global_attribute1
71: , ar_trx_lines_gt.global_attribute4
72: , ar_trx_lines_gt.global_attribute5
73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7

Line 71: , ar_trx_lines_gt.global_attribute4

67: , ar_trx_header_gt.global_attribute15
68: , ar_trx_header_gt.global_attribute16
69: , ar_trx_header_gt.global_attribute17
70: , ar_trx_lines_gt.global_attribute1
71: , ar_trx_lines_gt.global_attribute4
72: , ar_trx_lines_gt.global_attribute5
73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8

Line 72: , ar_trx_lines_gt.global_attribute5

68: , ar_trx_header_gt.global_attribute16
69: , ar_trx_header_gt.global_attribute17
70: , ar_trx_lines_gt.global_attribute1
71: , ar_trx_lines_gt.global_attribute4
72: , ar_trx_lines_gt.global_attribute5
73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9

Line 73: , ar_trx_lines_gt.global_attribute6

69: , ar_trx_header_gt.global_attribute17
70: , ar_trx_lines_gt.global_attribute1
71: , ar_trx_lines_gt.global_attribute4
72: , ar_trx_lines_gt.global_attribute5
73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9
77: , ar_trx_lines_gt.global_attribute10

Line 74: , ar_trx_lines_gt.global_attribute7

70: , ar_trx_lines_gt.global_attribute1
71: , ar_trx_lines_gt.global_attribute4
72: , ar_trx_lines_gt.global_attribute5
73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9
77: , ar_trx_lines_gt.global_attribute10
78: , ar_trx_lines_gt.global_attribute11

Line 75: , ar_trx_lines_gt.global_attribute8

71: , ar_trx_lines_gt.global_attribute4
72: , ar_trx_lines_gt.global_attribute5
73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9
77: , ar_trx_lines_gt.global_attribute10
78: , ar_trx_lines_gt.global_attribute11
79: , ar_trx_lines_gt.global_attribute12

Line 76: , ar_trx_lines_gt.global_attribute9

72: , ar_trx_lines_gt.global_attribute5
73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9
77: , ar_trx_lines_gt.global_attribute10
78: , ar_trx_lines_gt.global_attribute11
79: , ar_trx_lines_gt.global_attribute12
80: , warehouse_id

Line 77: , ar_trx_lines_gt.global_attribute10

73: , ar_trx_lines_gt.global_attribute6
74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9
77: , ar_trx_lines_gt.global_attribute10
78: , ar_trx_lines_gt.global_attribute11
79: , ar_trx_lines_gt.global_attribute12
80: , warehouse_id
81: , rbs.name

Line 78: , ar_trx_lines_gt.global_attribute11

74: , ar_trx_lines_gt.global_attribute7
75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9
77: , ar_trx_lines_gt.global_attribute10
78: , ar_trx_lines_gt.global_attribute11
79: , ar_trx_lines_gt.global_attribute12
80: , warehouse_id
81: , rbs.name
82: , ar_trx_header_gt.trx_number

Line 79: , ar_trx_lines_gt.global_attribute12

75: , ar_trx_lines_gt.global_attribute8
76: , ar_trx_lines_gt.global_attribute9
77: , ar_trx_lines_gt.global_attribute10
78: , ar_trx_lines_gt.global_attribute11
79: , ar_trx_lines_gt.global_attribute12
80: , warehouse_id
81: , rbs.name
82: , ar_trx_header_gt.trx_number
83: FROM ar_trx_lines_gt,ar_trx_header_gt,ra_batch_sources_all rbs

Line 83: FROM ar_trx_lines_gt,ar_trx_header_gt,ra_batch_sources_all rbs

79: , ar_trx_lines_gt.global_attribute12
80: , warehouse_id
81: , rbs.name
82: , ar_trx_header_gt.trx_number
83: FROM ar_trx_lines_gt,ar_trx_header_gt,ra_batch_sources_all rbs
84: WHERE ar_trx_lines_gt.request_id = c_request_id
85: AND ar_trx_header_gt.trx_header_id = ar_trx_lines_gt.trx_header_id
86: AND ar_trx_header_gt.batch_source_id = rbs.batch_source_id
87: ORDER BY ar_trx_header_gt.trx_date;

Line 84: WHERE ar_trx_lines_gt.request_id = c_request_id

80: , warehouse_id
81: , rbs.name
82: , ar_trx_header_gt.trx_number
83: FROM ar_trx_lines_gt,ar_trx_header_gt,ra_batch_sources_all rbs
84: WHERE ar_trx_lines_gt.request_id = c_request_id
85: AND ar_trx_header_gt.trx_header_id = ar_trx_lines_gt.trx_header_id
86: AND ar_trx_header_gt.batch_source_id = rbs.batch_source_id
87: ORDER BY ar_trx_header_gt.trx_date;
88:

Line 85: AND ar_trx_header_gt.trx_header_id = ar_trx_lines_gt.trx_header_id

81: , rbs.name
82: , ar_trx_header_gt.trx_number
83: FROM ar_trx_lines_gt,ar_trx_header_gt,ra_batch_sources_all rbs
84: WHERE ar_trx_lines_gt.request_id = c_request_id
85: AND ar_trx_header_gt.trx_header_id = ar_trx_lines_gt.trx_header_id
86: AND ar_trx_header_gt.batch_source_id = rbs.batch_source_id
87: ORDER BY ar_trx_header_gt.trx_date;
88:
89: ------------------------------------------------------------