DBA Data[Home] [Help]

APPS.SHP_PICKING_BATCHES_PKG dependencies on SO_REPORTS

Line 620: SO_REPORTS R

616: -- get pick slip printer
617: SELECT MAX(P.LEVEL_TYPE_ID)
618: INTO level_type_id
619: FROM SO_REPORT_PRINTERS P,
620: SO_REPORTS R
621: WHERE P.REPORT_ID = R.REPORT_ID
622: AND R.NAME =
623: NVL(report, default_report)
624: AND P.LEVEL_VALUE_ID = DECODE(P.LEVEL_TYPE_ID,

Line 634: SO_REPORTS R

630:
631: SELECT P.PRINTER_NAME
632: INTO printer
633: FROM SO_REPORT_PRINTERS P,
634: SO_REPORTS R
635: WHERE P.REPORT_ID = R.REPORT_ID
636: AND R.NAME =
637: NVL(report, default_report)
638: AND P.LEVEL_TYPE_ID = level_type_id