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.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_LINES

Line 70: From ozf_resale_lines_int

66:
67:
68: CURSOR OPEN_line_count_csr (p_id in NUMBER) IS
69: SELECT count(1)
70: From ozf_resale_lines_int
71: WHERE resale_batch_id = p_id
72: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
73: l_count NUMBER;
74:

Line 89: FROM ozf_resale_lines_int

85: p_cust_id in NUMBER,
86: p_date in DATE)
87: IS
88: SELECT resale_line_int_id
89: FROM ozf_resale_lines_int
90: WHERE resale_batch_id = p_id
91: AND order_number = p_order_number
92: AND sold_from_cust_account_id = p_cust_id
93: AND date_ordered = p_date

Line 112: , ozf_resale_lines_int b

108: , p_date IN DATE
109: ) IS
110: SELECT a.resale_header_id
111: FROM ozf_resale_headers a
112: , ozf_resale_lines_int b
113: , ozf_resale_lines c
114: WHERE b.resale_batch_id = p_id
115: AND b.order_number = p_order_number
116: AND b.sold_from_cust_account_id = p_cust_id

Line 113: , ozf_resale_lines c

109: ) IS
110: SELECT a.resale_header_id
111: FROM ozf_resale_headers a
112: , ozf_resale_lines_int b
113: , ozf_resale_lines c
114: WHERE b.resale_batch_id = p_id
115: AND b.order_number = p_order_number
116: AND b.sold_from_cust_account_id = p_cust_id
117: AND b.date_ordered = p_date

Line 131: FROM ozf_resale_lines_int

127: CURSOR batch_order_num_csr(p_id in NUMBER)is
128: SELECT DISTINCT order_number,
129: sold_from_cust_account_id,
130: date_ordered
131: FROM ozf_resale_lines_int
132: WHERE resale_batch_id = p_id
133: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)
134: --AND duplicated_adjustment_id <> -1
135: ORDER BY date_ordered;

Line 164: FROM ozf_resale_lines_int_all

160: , bill_to_city
161: , bill_to_state
162: , bill_to_postal_code
163: , bill_to_country
164: FROM ozf_resale_lines_int_all
165: WHERE resale_batch_id = cv_resale_batch_id
166: AND status_code = 'PROCESSED'
167: AND ( duplicated_line_id IS NULL
168: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 185: FROM ozf_resale_lines_int_all

181: , end_cust_state
182: , end_cust_postal_code
183: , end_cust_country
184: , end_cust_site_use_code
185: FROM ozf_resale_lines_int_all
186: WHERE resale_batch_id = cv_resale_batch_id
187: AND status_code = 'PROCESSED'
188: AND ( duplicated_line_id IS NULL
189: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 312: UPDATE ozf_resale_lines_int_all

308: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: UPDATE ozf_resale_lines_int_all
313: SET bill_to_party_id = l_new_party_rec.party_id
314: , bill_to_party_site_id = l_new_party_rec.party_site_id
315: WHERE resale_batch_id = p_resale_batch_id
316: AND bill_to_party_id IS NULL

Line 367: UPDATE ozf_resale_lines_int_all

363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: UPDATE ozf_resale_lines_int_all
368: SET end_cust_party_id = l_new_party_rec.party_id
369: , end_cust_party_site_id = l_new_party_rec.party_site_id
370: WHERE resale_batch_id = p_resale_batch_id
371: AND end_cust_party_id IS NULL

Line 427: UPDATE ozf_resale_lines_int_all

423:
424: -- There is something wrong with this order. dispute all the orders
425: -- and move to the next one.
426: -- JXWU move update to common pvt
427: UPDATE ozf_resale_lines_int_all
428: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
429: dispute_code = 'OZF_RESALE_MULTI_HEADER',
430: followup_action_code = 'C',
431: response_type = 'CA',

Line 503: UPDATE ozf_resale_lines_int

499: IF OZF_DEBUG_LOW_ON THEN
500: OZF_UTILITY_PVT.debug_message('Did NOT pass inventory checking');
501: END IF;
502: -- Here turn thIS line to DISPUTED AND create a dISput code FOR it.
503: UPDATE ozf_resale_lines_int
504: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
505: dispute_code = 'OZF_LT_INVT',
506: followup_action_code = 'C',
507: response_type = 'CA',

Line 669: UPDATE ozf_resale_lines_int

665:
666: -- UPDATE batch line status to CLOSEd for each OPEN and duplicated lines.
667:
668: BEGIN
669: UPDATE ozf_resale_lines_int
670: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
671: WHERE resale_batch_id = p_resale_batch_id
672: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);
673: --AND duplicated_adjustment_id <> -1;

Line 766: FROM ozf_resale_lines_int

762: l_msg_count NUMBER;
763:
764: CURSOR non_tracing_count_csr(p_id IN NUMBER) IS
765: SELECT COUNT(1)
766: FROM ozf_resale_lines_int
767: WHERE resale_batch_id = p_id
768: AND tracing_flag = 'F';
769:
770: l_non_tracing_count NUMBER;

Line 821: FROM ozf_resale_lines_int_all b

817: FND_MESSAGE.get_string('OZF','OZF_RESALE_NON_TRC'),
818: 'TRACING_FLAG',
819: tracing_flag,
820: org_id
821: FROM ozf_resale_lines_int_all b
822: WHERE b.status_code = 'OPEN'
823: AND b.tracing_flag = 'F'
824: AND b.resale_batch_id = p_resale_batch_id
825: AND NOT EXISTS(SELECT 1

Line 840: UPDATE ozf_resale_lines_int_all

836: p_token_value => l_full_name||': END');
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END;
839:
840: UPDATE ozf_resale_lines_int_all
841: SET status_code = 'DISPUTED',
842: dispute_code = 'OZF_RESALE_NON_TRC',
843: followup_action_code = 'C',
844: response_type = 'CA',

Line 924: FROM ozf_resale_lines_int

920: CURSOR order_num_csr IS
921: SELECT DISTINCT order_number,
922: sold_from_cust_account_id,
923: date_ordered
924: FROM ozf_resale_lines_int
925: WHERE status_code = 'OPEN'
926: -- status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
927: AND duplicated_adjustment_id IS NULL
928: AND resale_batch_id = p_resale_batch_id

Line 939: FROM ozf_resale_lines_int

935: CURSOR order_set_csr(p_order_NUMBER in VARCHAR2,
936: p_cust_account_id in NUMBER,
937: p_date in date) IS
938: SELECT *
939: FROM ozf_resale_lines_int
940: WHERE order_NUMBER = p_order_NUMBER
941: AND date_ordered = p_date
942: AND sold_from_cust_account_id = p_cust_account_id
943: AND status_code = 'OPEN'

Line 960: FROM ozf_resale_lines_int

956: l_lines_disputed NUMBER;
957:
958: CURSOR invalid_line_count_csr (p_id NUMBER) IS
959: SELECT COUNT(1)
960: FROM ozf_resale_lines_int
961: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED
962: AND dispute_code = OZF_RESALE_COMMON_PVT.G_INVALD_DISPUTE_CODE
963: AND resale_batch_id = p_id;
964: l_lines_invalid NUMBER;

Line 1147: UPDATE ozf_resale_lines_int

1143: IF OZF_DEBUG_LOW_ON THEN
1144: ozf_utility_PVT.debug_message('Did not pass inventory checking');
1145: END IF;
1146: -- Here turn this line to disputed and create a disput code for it.
1147: UPDATE ozf_resale_lines_int
1148: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1149: dispute_code = 'OZF_LT_INVT',
1150: followup_action_code = 'C',
1151: response_type = 'CA',

Line 1163: UPDATE ozf_resale_lines_int

1159:
1160: GOTO END_ORDER_LINE;
1161: ELSE
1162: -- This is a valid tracing line
1163: UPDATE ozf_resale_lines_int
1164: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
1165: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id;
1166: END IF;
1167: ELSE

Line 1169: UPDATE ozf_resale_lines_int

1165: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id;
1166: END IF;
1167: ELSE
1168: -- Set line status to Processed if not tracking inventory
1169: UPDATE ozf_resale_lines_int
1170: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
1171: WHERE resale_line_int_Id = l_order_set_tbl(j).resale_line_int_id;
1172: END IF;
1173: << END_ORDER_LINE >>