APPS.PMI_SALES_PKG dependencies on SY_ORGN_MST

Line 6: FUNCTION PMISA_GET_TOP_N(p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,

2: /* $Header: PMISAANB.pls 115.5 2003/02/19 04:47:42 srpuri ship $ */
3:
4: /* Added New function SKARIMIS 12/28/1999 */
5:
6: FUNCTION PMISA_GET_TOP_N(p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
7: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
8: p_Prd_start_date IN DATE,
9: p_Prd_end_date IN DATE,
10: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,

Line 18: Cursor cur_item ( p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,

14: RETURN NUMBER
15: IS
16: /* cursor to Fetch Top products with respect to margin */
17:
18: Cursor cur_item ( p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
19: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
20: p_Prd_start_date IN DATE,
21: p_Prd_end_date IN DATE
22: )

Line 48: Cursor cur_customer ( p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,

44: AND orderhdr.ORGN_CODE=p_Sales_orgn
45: GROUP BY orderhdr.orgn_code,orderdetail.item_id
46: ORDER BY Margin desc;
47: /* Cursor to get Top N customers with respect to Margin */
48: Cursor cur_customer ( p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
49: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
50: p_Prd_start_date IN DATE,
51: p_Prd_end_date IN DATE
52: )

Line 222: SY_ORGN_MST org,

218: FROM
219: OP_ORDR_HDR orderhdr,
220: OP_ORDR_DTL orderdetail,
221: IC_ITEM_MST itemmst,
222: SY_ORGN_MST org,
223: GL_PLCY_MST pol
224: WHERE orderhdr.order_id = orderdetail.order_id
225: AND orderdetail.item_id = itemmst.item_id
226: AND trunc(orderdetail.ACTUAL_SHIPDATE)

Line 308: SY_ORGN_MST org,

304: FROM
305: OP_ORDR_HDR orderhdr,
306: OP_ORDR_DTL orderdetail,
307: IC_ITEM_MST itemmst,
308: SY_ORGN_MST org,
309: GL_PLCY_MST pol
310: WHERE orderhdr.order_id = orderdetail.order_id
311: AND orderdetail.item_id = itemmst.item_id
312: AND trunc(orderdetail.ACTUAL_SHIPDATE)

Line 473: FUNCTION PMISA_VALIDATE_DATE(p_Sales_Company IN sy_orgn_mst.co_code%TYPE,

469: END IF;
470: END PMISA_GET_TOP_N_BY_OU;
471:
472:
473: FUNCTION PMISA_VALIDATE_DATE(p_Sales_Company IN sy_orgn_mst.co_code%TYPE,
474: p_From_year IN number,
475: p_To_year IN number,
476: p_From_period IN pmi_gl_calendar_v.period_name%TYPE,
477: p_To_period IN pmi_gl_calendar_v.period_name%TYPE,