[Home] [Help]
388: intf_lines.interface_line_id,
389: intf_lines.line_num
390: FROM po_headers_interface intf_headers,
391: po_lines_interface intf_lines,
392: po_lines_draft_all draft_lines
393: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
394: AND intf_headers.draft_id = draft_lines.draft_id
395: AND intf_headers.po_header_id = draft_lines.po_header_id
396: AND intf_lines.processing_id = p_request_processing_id
3586: order_type_lookup_code,
3587: item_id,
3588: job_id,
3589: po_header_id --vegajula bugno:9531925
3590: FROM po_lines_draft_all
3591: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3592: AND draft_id = x_lines.draft_id_tbl(i);
3593:
3594: d_position := 20;
3604: po_header_id --vegajula bugno:9531925
3605: FROM po_lines_all
3606: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3607: AND NOT EXISTS (SELECT 1
3608: FROM po_lines_draft_all
3609: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3610: AND draft_id = x_lines.draft_id_tbl(i));
3611:
3612: d_position := 30;
6686: INSERT INTO po_session_gt(key, num1, num2)
6687: SELECT l_key,
6688: p_index_tbl(i),
6689: po_line_id
6690: FROM po_lines_draft_all
6691: WHERE draft_id = x_lines.draft_id_tbl(i)
6692: AND po_header_id = x_lines.po_header_id_tbl(i)
6693: AND line_num = x_lines.line_num_tbl(i)
6694: AND NVL(delete_flag, 'N') <> 'Y';
6871: SELECT l_key,
6872: l_processing_line_tbl(i),
6873: po_line_id,
6874: line_num
6875: FROM po_lines_draft_all
6876: WHERE x_lines.item_id_tbl(i) IS NOT NULL
6877: AND draft_id = x_lines.draft_id_tbl(i)
6878: AND po_header_id = x_lines.po_header_id_tbl(i)
6879: AND item_id = x_lines.item_id_tbl(i)
6893: SELECT l_key,
6894: l_processing_line_tbl(i),
6895: po_line_id,
6896: line_num
6897: FROM po_lines_draft_all
6898: WHERE x_lines.item_id_tbl(i) IS NULL
6899: AND draft_id = x_lines.draft_id_tbl(i)
6900: AND po_header_id = x_lines.po_header_id_tbl(i)
6901: AND item_description = x_lines.item_desc_tbl(i)
7432: p_key,
7433: x_processing_row_tbl(i),
7434: draft_lines.po_line_id,
7435: draft_lines.line_num
7436: FROM po_lines_draft_all draft_lines
7437: WHERE draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7438: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7439: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7440: AND draft_lines.item_description = x_lines.item_desc_tbl(i)
7462: txn_lines.line_num
7463: FROM po_lines txn_lines
7464: WHERE txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7465: AND NOT EXISTS ( SELECT 1
7466: FROM po_lines_draft_all draft_lines
7467: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7468: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7469: AND txn_lines.item_description = x_lines.item_desc_tbl(i)
7470: AND (x_lines.category_tbl(i) IS NULL OR
7706: p_key,
7707: x_processing_row_tbl(i),
7708: draft_lines.po_line_id,
7709: draft_lines.line_num
7710: FROM po_lines_draft_all draft_lines
7711: WHERE x_lines.item_tbl(i) IS NOT NULL
7712: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7713: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7714: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7745: FROM po_lines txn_lines
7746: WHERE x_lines.item_tbl(i) IS NOT NULL
7747: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7748: AND NOT EXISTS ( SELECT 1
7749: FROM po_lines_draft_all draft_lines
7750: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7751: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7752: AND EXISTS (SELECT 1
7753: FROM mtl_system_items items
7988: p_key,
7989: x_processing_row_tbl(i),
7990: draft_lines.po_line_id,
7991: draft_lines.line_num
7992: FROM po_lines_draft_all draft_lines
7993: WHERE x_lines.item_tbl(i) IS NULL
7994: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
7995: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7996: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
8020: WHERE x_lines.item_tbl(i) IS NULL
8021: AND x_lines.vendor_product_num_tbl(i) IS NOT NULL
8022: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8023: AND NOT EXISTS ( SELECT 1
8024: FROM po_lines_draft_all draft_lines
8025: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8026: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8027: AND txn_lines.vendor_product_num = x_lines.vendor_product_num_tbl(i)
8028: AND NVL(x_lines.supplier_part_auxid_tbl(i),
8246: p_key,
8247: x_processing_row_tbl(i),
8248: draft_lines.po_line_id,
8249: draft_lines.line_num
8250: FROM po_lines_draft_all draft_lines
8251: WHERE x_lines.item_tbl(i) IS NULL
8252: AND x_lines.vendor_product_num_tbl(i) IS NULL
8253: AND x_lines.job_name_tbl(i) IS NOT NULL
8254: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8281: AND x_lines.vendor_product_num_tbl(i) IS NULL
8282: AND x_lines.job_name_tbl(i) IS NOT NULL
8283: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8284: AND NOT EXISTS ( SELECT 1
8285: FROM po_lines_draft_all draft_lines
8286: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8287: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8288: AND EXISTS (SELECT 1
8289: FROM per_jobs_vl
8501: p_key,
8502: x_processing_row_tbl(i),
8503: draft_lines.po_line_id,
8504: draft_lines.line_num
8505: FROM po_lines_draft_all draft_lines
8506: WHERE x_lines.item_tbl(i) IS NULL
8507: AND x_lines.vendor_product_num_tbl(i) IS NULL
8508: AND x_lines.job_name_tbl(i) IS NULL
8509: AND x_lines.line_num_tbl(i) IS NOT NULL
8534: AND x_lines.job_name_tbl(i) IS NULL
8535: AND x_lines.line_num_tbl(i) IS NOT NULL
8536: AND txn_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8537: AND NOT EXISTS ( SELECT 1
8538: FROM po_lines_draft_all draft_lines
8539: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8540: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8541: AND txn_lines.line_num = x_lines.line_num_tbl(i)
8542: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)