APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_BATCH_LINE_MAPS

Line 1091: ,ozf_resale_batch_line_maps map

1087: UNION
1088: SELECT COUNT(orig_system_item_number) pt_cnt
1089: FROM ozf_resale_lines lin
1090: ,ozf_resale_batches bat
1091: ,ozf_resale_batch_line_maps map
1092: WHERE orig_system_item_number = cv_external_code
1093: AND lin.resale_line_id = map.resale_line_id
1094: AND bat.resale_batch_id = map.resale_batch_id
1095: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;

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

1209:
1210:
1211: IF G_PARTY_ID IS NOT NULL THEN
1212:
1213: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1214: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1215: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1216: l_sql := l_sql|| 'AND '||l_where ||') ';
1217:

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

1400: ' OR ship_to_party_name = :1 )';
1401:
1402:
1403: IF G_PARTY_ID IS NOT NULL THEN
1404: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1405: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1406: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';
1407:
1408: l_where := l_where||' AND bat.partner_party_id = :2 ' ;

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

1491: ' OR ship_to_location = :1 )';
1492:
1493: -- fix for 5226248
1494: IF G_PARTY_ID IS NOT NULL THEN
1495: l_sql := l_sql||'ozf_resale_batches bat, ozf_resale_lines lin ,ozf_resale_batch_line_maps map ';
1496: l_interface_sql := l_sql ||'ozf_resale_batches bat, ozf_resale_lines_int lin '||
1497: ' WHERE lin.resale_batch_id = bat.resale_batch_id ';
1498: l_sql := l_sql||'WHERE lin.resale_line_id = map.resale_line_id ';
1499: l_sql := l_sql||'AND map.resale_batch_id = bat.resale_batch_id ';