[Home] [Help]
377: AND (Accounting_Date between NVL(l_Start_Date, to_date('0001-01-01', 'YYYY-MM-DD')) and NVL(l_End_Date, to_date('9999-01-01', 'YYYY-MM-DD')))
378: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
379: AND POSTED_FLAG = 'Y'
380: ) DIST,
381: PA_Projects_ALL PAP,
382: PJM_Org_Parameters POP,
383: PO_Distributions_All POD
384: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
385: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
447: AND (C.Accounting_Date between NVL(l_Start_Date, to_date('0001-01-01', 'YYYY-MM-DD')) and NVL(l_End_Date, to_date('9999-01-01', 'YYYY-MM-DD')))
448: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
449: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
450: ) DIST,
451: PA_Projects_ALL PAP,
452: PJM_Org_Parameters POP,
453: PO_Distributions_All POD
454: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
455: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
512: WHERE LINE_TYPE_LOOKUP_CODE IN ('IPV', 'ERV', 'TIPV', 'TERV', 'TRV')
513: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
514: AND POSTED_FLAG = 'Y'
515: ) DIST,
516: PA_Projects_ALL PAP,
517: PJM_Org_Parameters POP,
518: PO_Distributions_All POD
519: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
520: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
584: AND C.POSTED_FLAG = 'Y'
585: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
586: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
587: ) DIST,
588: PA_Projects_ALL PAP,
589: PJM_Org_Parameters POP,
590: PO_Distributions_All POD
591: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
592: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')