APPS.JL_ZZ_INVOICE_CREATE dependencies on AR_TRX_HEADER_GT

Line 46: , ar_trx_header_gt.cust_trx_type_id trx_type

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
50: , ar_trx_lines_gt.line_type

Line 47: , ar_trx_header_gt.trx_date

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
50: , ar_trx_lines_gt.line_type
51: , ar_trx_lines_gt.memo_line_id

Line 53: , ar_trx_header_gt.global_attribute1

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
57: , ar_trx_header_gt.global_attribute5

Line 54: , ar_trx_header_gt.global_attribute2

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
57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6

Line 55: , ar_trx_header_gt.global_attribute3

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
57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7

Line 56: , ar_trx_header_gt.global_attribute4

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
57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8

Line 57: , ar_trx_header_gt.global_attribute5

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
57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9

Line 58: , ar_trx_header_gt.global_attribute6

54: , ar_trx_header_gt.global_attribute2
55: , ar_trx_header_gt.global_attribute3
56: , ar_trx_header_gt.global_attribute4
57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10

Line 59: , ar_trx_header_gt.global_attribute7

55: , ar_trx_header_gt.global_attribute3
56: , ar_trx_header_gt.global_attribute4
57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11

Line 60: , ar_trx_header_gt.global_attribute8

56: , ar_trx_header_gt.global_attribute4
57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12

Line 61: , ar_trx_header_gt.global_attribute9

57: , ar_trx_header_gt.global_attribute5
58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13

Line 62: , ar_trx_header_gt.global_attribute10

58: , ar_trx_header_gt.global_attribute6
59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13
66: , ar_trx_header_gt.global_attribute14

Line 63: , ar_trx_header_gt.global_attribute11

59: , ar_trx_header_gt.global_attribute7
60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13
66: , ar_trx_header_gt.global_attribute14
67: , ar_trx_header_gt.global_attribute15

Line 64: , ar_trx_header_gt.global_attribute12

60: , ar_trx_header_gt.global_attribute8
61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13
66: , ar_trx_header_gt.global_attribute14
67: , ar_trx_header_gt.global_attribute15
68: , ar_trx_header_gt.global_attribute16

Line 65: , ar_trx_header_gt.global_attribute13

61: , ar_trx_header_gt.global_attribute9
62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13
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

Line 66: , ar_trx_header_gt.global_attribute14

62: , ar_trx_header_gt.global_attribute10
63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13
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

Line 67: , ar_trx_header_gt.global_attribute15

63: , ar_trx_header_gt.global_attribute11
64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13
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

Line 68: , ar_trx_header_gt.global_attribute16

64: , ar_trx_header_gt.global_attribute12
65: , ar_trx_header_gt.global_attribute13
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

Line 69: , ar_trx_header_gt.global_attribute17

65: , ar_trx_header_gt.global_attribute13
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

Line 82: , ar_trx_header_gt.trx_number

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
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

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 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: ------------------------------------------------------------

Line 86: AND ar_trx_header_gt.batch_source_id = rbs.batch_source_id

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: ------------------------------------------------------------
90: -- Main function body. --

Line 87: ORDER BY ar_trx_header_gt.trx_date;

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: ------------------------------------------------------------
90: -- Main function body. --
91: ------------------------------------------------------------