APPS.CTO_AUTO_PROCURE_PK dependencies on PO_LINES_ALL

Line 3094: From po_lines_all pol,

3090: begin
3091:
3092: Select 'X'
3093: into line_exists
3094: From po_lines_all pol,
3095: Po_headers_all poh
3096: Where
3097: poh.type_lookup_code = 'BLANKET'
3098: AND poh.approved_flag = 'Y'

Line 3141: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;

3137: l_model_qty Number := 0;
3138: l_ratio Number;
3139: l_prim_uom_qty Number;
3140: l_prim_uom Bom_cto_order_lines.order_quantity_uom%type;
3141: l_po_uom_code po_lines_all.unit_meas_lookup_code%type;
3142: l_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3143: l_conv_qty Number;
3144: l_model_po_uom Bom_cto_order_lines.order_quantity_uom%type;
3145: l_model_order_uom Bom_cto_order_lines.order_quantity_uom%type;

Line 3195: From po_lines_all pol,

3191: Select pol.unit_price,
3192: muom.uom_code
3193: into l_unit_price,
3194: l_po_uom
3195: From po_lines_all pol,
3196: Po_headers_all poh,
3197: mtl_units_of_measure muom
3198: Where
3199: poh.type_lookup_code = 'BLANKET'

Line 3486: from po_lines_all pol,

3482: pol.closed_date,
3483: pol.tax_code_id,
3484: decode(poh.start_date,null,p_start_date,poh.start_date),
3485: decode(poh.end_date,null,p_end_date,poh.end_date)
3486: from po_lines_all pol,
3487: po_headers_all poh
3488: where pol.po_line_id =p_doc_line_id
3489: and poh.po_header_id = pol.po_header_id;
3490:

Line 3584: po_lines_all pol

3580: sysdate
3581: -- p_price*poll.price_discount/100
3582: -- price_discount
3583: from po_line_locations_all poll,
3584: po_lines_all pol
3585: where pol.po_line_id = p_doc_line_id
3586: and pol.po_line_id = poll.po_line_id;
3587:
3588: IF PG_DEBUG <> 0 THEN