DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on FND_LOOKUP_VALUES_VL

Line 668: fnd_lookup_values_vl flv

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
672: AND nvl(flv.end_date_active,sysdate)>=sysdate

Line 718: fnd_lookup_values_vl flv

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
722: AND nvl(flv.end_date_active,sysdate)>=sysdate

Line 773: fnd_lookup_values_vl flv

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
777: AND nvl(flv.end_date_active,sysdate)>=sysdate