[Home] [Help]
55: v_rate_date DATE;
56: v_edw_global_rate_type edw_local_system_parameters.rate_type%type;
57: v_edw_global_currency_code EDW_LOCAL_SYSTEM_PARAMETERS.warehouse_currency_code%type;
58: --
59: /* cursor to look at all standard POs which non-one-time-items that exist
60: * in blankets. We still need to check whether all the criteria
61: * for the item match those stated in the blankets.
62: */
63: CURSOR C_STD_PO (c_batch_no NUMBER) IS
88: WHERE inc.primary_key = pod.PO_DISTRIBUTION_ID
89: and phc.po_header_id = plc.po_header_id
90: and plc.po_line_id = psc.po_line_id
91: and psc.line_location_id = pod.line_location_id
92: and psc.shipment_type = 'STANDARD'
93: and phc.style_id = style.style_id
94: and nvl(style.progress_payment_flag,'N') = 'N'
95: and psc.approved_flag = 'Y'
96: and plc.contract_id is null
330: WHERE inc.primary_key = pod.PO_DISTRIBUTION_ID
331: and phc.po_header_id = plc.po_header_id
332: and plc.po_line_id = psc.po_line_id
333: and psc.line_location_id = pod.line_location_id
334: and psc.shipment_type = 'STANDARD'
335: and phc.style_id = style.style_id
336: and nvl(style.progress_payment_flag,'N') = 'N'
337: AND plc.from_header_id = ga.po_header_id(+)
338: AND Nvl(ga.global_agreement_flag, 'N') = 'N'
512: WHERE inc.primary_key = pod.PO_DISTRIBUTION_ID
513: and phc.po_header_id = plc.po_header_id
514: and plc.po_line_id = psc.po_line_id
515: and psc.line_location_id = pod.line_location_id
516: and psc.shipment_type = 'STANDARD'
517: and phc.style_id = style.style_id
518: and nvl(style.progress_payment_flag,'N') = 'N'
519: and psc.approved_flag = 'Y'
520: and plc.contract_id is NULL