APPS.PO_COPYDOC_S3 dependencies on PO_LINE_TYPES

Line 45: FROM PO_LINE_TYPES

41:
42: x_progress := '001';
43: SELECT distinct 'Y'
44: INTO x_valid_flag
45: FROM PO_LINE_TYPES
46: WHERE line_type_id = x_line_type_id
47: AND SYSDATE < nvl(inactive_date, SYSDATE+1)
48: AND ((nvl(outside_operation_flag,'N') = 'Y' AND x_wip_install_status = 'I')
49: OR (nvl(outside_operation_flag, 'N') <> 'Y'));

Line 148: x_order_type_lookup_code po_line_types.order_type_lookup_code%type;

144: x_quotation_class_code VARCHAR2(10) := NULL;
145: x_orig_po_header_id po_lines.po_header_id%TYPE := NULL;
146: x_qty po_lines.quantity%type := NULL;
147: x_blanket_price po_lines.unit_price%type := NULL;
148: x_order_type_lookup_code po_line_types.order_type_lookup_code%type;
149: -- start of 1548597
150: x_secondary_qty po_lines.secondary_quantity%type := NULL;
151: x_item_number VARCHAR2(240);
152: x_process_org VARCHAR2(1);

Line 283: FROM po_line_types

279: x_progress := '001';
280: begin
281: SELECT order_type_lookup_code
282: INTO x_order_type_lookup_code
283: FROM po_line_types
284: WHERE line_type_id = x_po_line_record.line_type_id;
285: exception
286: when others then
287: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,