APPS.CHV_BUILD_SCHEDULES dependencies on PO_LINES

Line 2071: po_lines pol

2067: SELECT min(poh.po_header_id)
2068: INTO x_po_header_id_l
2069: FROM po_headers poh,
2070: chv_item_orders cio,
2071: po_lines pol
2072: WHERE poh.creation_date =
2073: (SELECT min(poh2.creation_date)
2074: FROM po_headers poh2,
2075: po_lines pol2,

Line 2075: po_lines pol2,

2071: po_lines pol
2072: WHERE poh.creation_date =
2073: (SELECT min(poh2.creation_date)
2074: FROM po_headers poh2,
2075: po_lines pol2,
2076: chv_item_orders cio2
2077: WHERE cio2.schedule_id = x_schedule_id
2078: AND poh2.po_header_id = cio2.document_header_id
2079: AND cio2.schedule_item_id = x_schedule_item_id_l

Line 2099: FROM po_lines pol

2095: x_progress := '125';
2096:
2097: SELECT min(pol.po_line_id)
2098: INTO x_po_line_id_l
2099: FROM po_lines pol
2100: WHERE pol.po_header_id = x_po_header_id_l
2101: AND pol.item_id = x_item_id_l;
2102:
2103: ELSE

Line 2166: po_lines pol,

2162:
2163: SELECT min(poh.po_header_id)
2164: INTO x_po_header_id_l
2165: FROM po_headers poh,
2166: po_lines pol,
2167: po_asl_documents pad
2168: WHERE poh.creation_date =
2169: (SELECT min(poh2.creation_date)
2170: FROM po_headers poh2,

Line 2171: po_lines pol2,

2167: po_asl_documents pad
2168: WHERE poh.creation_date =
2169: (SELECT min(poh2.creation_date)
2170: FROM po_headers poh2,
2171: po_lines pol2,
2172: po_asl_documents pad2
2173: WHERE poh2.po_header_id = pad2.document_header_id
2174: AND pad2.asl_id = x_asl_id_l
2175: AND pad2.using_organization_id = x_using_org_id_l

Line 2193: FROM po_lines pol,

2189: ---- dbms_output.put_line('Create_items: select min line id');
2190:
2191: SELECT min(pol.po_line_id)
2192: INTO x_po_line_id_l
2193: FROM po_lines pol,
2194: po_asl_documents
2195: WHERE pol.po_header_id = x_po_header_id_l
2196: AND pol.item_id = x_item_id_l
2197: AND pol.po_header_id = document_header_id

Line 2210: po_lines pol

2206:
2207: SELECT min(poh.po_header_id)
2208: INTO x_po_header_id_l
2209: FROM po_headers poh,
2210: po_lines pol
2211: WHERE poh.creation_date =
2212: (SELECT min(poh2.creation_date)
2213: FROM po_headers poh2,
2214: po_lines pol2

Line 2214: po_lines pol2

2210: po_lines pol
2211: WHERE poh.creation_date =
2212: (SELECT min(poh2.creation_date)
2213: FROM po_headers poh2,
2214: po_lines pol2
2215: WHERE poh2.po_header_id = pol2.po_header_id
2216: AND pol2.item_id = x_item_id_l
2217: AND poh2.type_lookup_code = 'BLANKET'
2218: AND poh2.authorization_status = 'APPROVED'

Line 2236: FROM po_lines pol

2232: ---- dbms_output.put_line('Create_items: select min line id');
2233:
2234: SELECT min(pol.po_line_id)
2235: INTO x_po_line_id_l
2236: FROM po_lines pol
2237: WHERE pol.po_header_id = x_po_header_id_l
2238: AND pol.item_id = x_item_id_l
2239: AND nvl(pol.cancel_flag,'N') = 'N'
2240: AND nvl(pol.closed_code,'OPEN') = 'OPEN';