APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_BATCH_LINE_MAPS

Line 1104: ,ozf_resale_batch_line_maps map

1100: UNION
1101: SELECT COUNT(orig_system_item_number) pt_cnt
1102: FROM ozf_resale_lines lin
1103: ,ozf_resale_batches bat
1104: ,ozf_resale_batch_line_maps map
1105: WHERE orig_system_item_number = cv_external_code
1106: AND lin.resale_line_id = map.resale_line_id
1107: AND bat.resale_batch_id = map.resale_batch_id
1108: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;

Line 1226: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';

1222:
1223:
1224: IF G_PARTY_ID IS NOT NULL THEN
1225:
1226: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1227: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1228: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1229: l_sql := l_sql|| 'AND '||l_where ||') ';
1230:

Line 1417: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';

1413: ' OR ship_to_party_name = :1 )';
1414:
1415:
1416: IF G_PARTY_ID IS NOT NULL THEN
1417: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1418: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1419: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1420:
1421: l_where := l_where||' AND bat.partner_party_id = :2 ' ;

Line 1508: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';

1504: ' OR ship_to_location = :1 )';
1505:
1506: -- fix for 5226248
1507: IF G_PARTY_ID IS NOT NULL THEN
1508: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1509: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1510: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1511: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1512: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';