APPS.POS_CREATE_ASN dependencies on PO_DOC_STYLE_HEADERS

Line 681: l_clm_flag po_doc_style_headers.clm_flag%TYPE;

677: l_amount_billed NUMBER;
678: l_quantity_cancelled NUMBER;
679: l_amount_cancelled NUMBER;
680: l_return_status VARCHAR2(1000);
681: l_clm_flag po_doc_style_headers.clm_flag%TYPE;
682:
683: BEGIN
684:
685: x_progress := '005';

Line 763: PO_DOC_STYLE_HEADERS PDSH

759: SELECT Nvl(PDSH.CLM_FLAG,'N') CLM_FLAG
760: INTO l_clm_flag
761: FROM PO_HEADERS_ALL POH,
762: PO_LINE_LOCATIONS_ALL POLL,
763: PO_DOC_STYLE_HEADERS PDSH
764: WHERE POLL.LINE_LOCATION_ID = l_line_location_id AND
765: POLL.PO_HEADER_ID = POH.PO_HEADER_ID AND
766: NVL(POH.STYLE_ID, 1) = PDSH.STYLE_ID (+) AND
767: PDSH.STATUS (+) = 'ACTIVE' AND