APPS.OE_BIS_CUST_SAT_SUMMARY dependencies on OE_BIS_CUST_SAT_T

Line 93: insert into oe_bis_cust_sat_t (

89: PROGRAM_UPDATE_DATE Who Column NUMBER(15)
90: */
91:
92:
93: insert into oe_bis_cust_sat_t (
94: ORGANIZATION_ID,
95: INVENTORY_ITEM_ID,
96: CUSTOMER_ID,
97: TRANSACTION_DATE,

Line 152: insert into oe_bis_cust_sat_t (

148:
149:
150: /* FOR RETURNS */
151:
152: insert into oe_bis_cust_sat_t (
153: ORGANIZATION_ID,
154: INVENTORY_ITEM_ID,
155: CUSTOMER_ID,
156: TRANSACTION_DATE,

Line 260: sql_stmt := 'insert into oe_bis_cust_sat_t2 ( SET_OF_BOOKS_ID,

256:
257:
258: if app_col_name = ' ' then
259:
260: sql_stmt := 'insert into oe_bis_cust_sat_t2 ( SET_OF_BOOKS_ID,
261: SET_OF_BOOKS_NAME,
262: LEGAL_ENTITY_ID,
263: LEGAL_ENTITY_NAME,
264: OPERATING_UNIT_ID,

Line 325: oe_bis_cust_sat_t obcs,

321: gl_periods year,
322: gl_periods quarter,
323: gl_periods month,
324: gl_sets_of_books gsob,
325: oe_bis_cust_sat_t obcs,
326: org_organization_definitions ood,
327: ra_customers rc,
328: hr_all_organization_units haou,
329: hr_locations_v hl,

Line 371: sql_stmt := 'insert into oe_bis_cust_sat_t2 ( SET_OF_BOOKS_ID,

367: trunc(obcs.transaction_date) between trunc(quarter.start_date) and trunc(quarter.end_date) and
368: trunc(obcs.transaction_date) between trunc(month.start_date) and trunc(month.end_date) ' ;
369: else
370:
371: sql_stmt := 'insert into oe_bis_cust_sat_t2 ( SET_OF_BOOKS_ID,
372: SET_OF_BOOKS_NAME,
373: LEGAL_ENTITY_ID,
374: LEGAL_ENTITY_NAME,
375: OPERATING_UNIT_ID,

Line 438: oe_bis_cust_sat_t obcs,

434: gl_periods year,
435: gl_periods quarter,
436: gl_periods month,
437: gl_sets_of_books gsob,
438: oe_bis_cust_sat_t obcs,
439: org_organization_definitions ood,
440: ra_customers rc,
441: hr_all_organization_units haou,
442: hr_locations_v hl,