APPS.PO_VAL_LINES dependencies on PO_LINES_INTERFACE

Line 4145: FROM po_lines_interface pclin

4141:
4142: FOR i IN 1 .. p_intf_line_id_tbl.count LOOP
4143: SELECT Count(interface_line_id)
4144: INTO l_line_count
4145: FROM po_lines_interface pclin
4146: WHERE pclin.interface_line_id = p_intf_line_id_tbl(i)
4147: AND pclin.group_line_id IS NULL /*clin*/
4148: AND Nvl(pclin.clm_info_flag,'N') = 'N' /*priced clin*/
4149: --AND Nvl(PLI.draft_id,-1) = Nvl(p_draft_id_tbl(i),-1)

Line 4152: FROM po_lines_interface

4148: AND Nvl(pclin.clm_info_flag,'N') = 'N' /*priced clin*/
4149: --AND Nvl(PLI.draft_id,-1) = Nvl(p_draft_id_tbl(i),-1)
4150: AND EXISTS ( --Priced SLIN
4151: SELECT interface_line_id
4152: FROM po_lines_interface
4153: WHERE interface_header_id = pclin.interface_header_id
4154: AND group_line_id IS NOT NULL
4155: AND Nvl(clm_info_flag,'N') = 'N'
4156: AND group_line_id = pclin.interface_line_id

Line 4563: FROM po_lines_interface

4559: IF p_clm_option_indicator_tbl(i) = 'O'
4560: THEN
4561: BEGIN
4562: SELECT interface_header_id INTO l_intf_header_id
4563: FROM po_lines_interface
4564: WHERE interface_line_id = p_intf_line_id_tbl(i);
4565:
4566: SELECT Nvl(clm_info_flag,'N'),
4567: Nvl(clm_option_indicator,'*')

Line 4570: FROM po_lines_interface

4566: SELECT Nvl(clm_info_flag,'N'),
4567: Nvl(clm_option_indicator,'*')
4568: INTO l_clm_info_flag,
4569: l_clm_option_indicator
4570: FROM po_lines_interface
4571: WHERE interface_line_id = p_clm_base_line_num_tbl(i)
4572: AND interface_header_id = l_intf_header_id;
4573:
4574: IF l_clm_info_flag <> 'N' --OR l_clm_option_indicator <> 'B'

Line 4676: FROM po_lines_interface

4672: l_dup_option_num_count := 0;
4673:
4674: SELECT Count(interface_line_id)
4675: INTO l_dup_option_num_count
4676: FROM po_lines_interface
4677: WHERE clm_base_line_num = Nvl(p_clm_base_line_num_tbl(i),-1)
4678: AND clm_option_num = p_clm_option_num_tbl(i);
4679:
4680: IF l_dup_option_num_count > 0

Line 4912: FROM po_headers_draft_all phd, po_headers_interface phi, po_lines_interface pli

4908: num1)
4909: SELECT
4910: l_data_key,
4911: p_intf_line_id_tbl(i)
4912: FROM po_headers_draft_all phd, po_headers_interface phi, po_lines_interface pli
4913: WHERE phd.po_header_id = phi.po_header_id
4914: AND phd.type_lookup_code = 'STANDARD'
4915: AND phi.interface_header_id = PLI.interface_header_id
4916: AND PLI.interface_line_id = p_intf_line_id_tbl(i)