APPS.PO_CONTRACTS_S dependencies on STANDARD

Line 170: AND pll.shipment_type = 'STANDARD'; --14795699

166: AND poh2.po_header_id = pol.po_header_id
167: AND (( poh2.authorization_status = 'APPROVED')
168: or (poh2.authorization_status = 'IN PROCESS'))
169: AND pol.po_header_id <> X_po_header_id
170: AND pll.shipment_type = 'STANDARD'; --14795699
171:
172: --dbms_output.put_line('X_purchased_amount = ' || X_purchased_amount);
173:
174: /* Go get the amount that is trying to be approved for this contract

Line 210: AND pll.shipment_type = 'STANDARD'; --14795699

206: WHERE pol.contract_id = X_contract_id --
207: AND pol.po_line_id = pll.po_line_id
208: AND pol.po_header_id = potoapp.po_header_id
209: AND potoapp.po_header_id = X_po_header_id
210: AND pll.shipment_type = 'STANDARD'; --14795699
211:
212: --dbms_output.put_line('X_current_amount = ' || X_current_amount);
213:
214: /* Check to see that the amount used on other po's + the amount