DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on PO_HEADERS

Line 667: FROM po_headers poh,

663: , Decode(p_manual_po_num_type,'NUMERIC', null, poh.segment1 ) FIELD9
664: , to_char(Decode(p_manual_po_num_type,'NUMERIC', to_number(poh.segment1),null)) FIELD10
665: , null FIELD11
666: , lookup_code FIELD12
667: FROM po_headers poh,
668: fnd_lookup_values_vl flv
669: WHERE flv.lookup_code = 'PO'
670: AND flv.lookup_type = 'DOC_TYPE'
671: AND nvl(flv.start_date_active, sysdate)<=sysdate

Line 717: FROM po_headers poh,

713: , Decode(p_manual_po_num_type,'NUMERIC', null, poh.segment1 ) FIELD9
714: , to_char(Decode(p_manual_po_num_type,'NUMERIC', to_number(poh.segment1),null)) FIELD10
715: , null FIELD11
716: , lookup_code FIELD12
717: FROM po_headers poh,
718: fnd_lookup_values_vl flv
719: WHERE flv.lookup_code = 'PO'
720: AND flv.lookup_type = 'DOC_TYPE'
721: AND nvl(flv.start_date_active, sysdate)<=sysdate

Line 772: FROM po_headers poh,

768: , Decode(p_manual_po_num_type,'NUMERIC', null, poh.segment1 ) FIELD9
769: , to_char(Decode(p_manual_po_num_type,'NUMERIC', to_number(poh.segment1),null)) FIELD10
770: , null FIELD11
771: , lookup_code FIELD12
772: FROM po_headers poh,
773: fnd_lookup_values_vl flv
774: WHERE flv.lookup_code = 'PO'
775: AND flv.lookup_type = 'DOC_TYPE'
776: AND nvl(flv.start_date_active, sysdate)<=sysdate